Show/Hide Fields in PowerApps

[Olijk]

Hello,

I am trying to do a show/hide field in Power Apps based number field.  For example, if the amount field is greater than 10000.00, then the approvers name would populate.  I used: =DataCardValue10.Selected.Value > "10000.00" and =DataCardValue10.Selected.Value > 10000.00 and nothing worked.  I received an error message on both formulas.  Thank you!

[Olijk]

Hello,

Ok thank you!  Would it have anything to do with the field I am trying to place the conditional formatting on being a combo box?

[Drrickryp]

@Olijk 

It might.  What is the Items property of the combobox and is it multiselect or single?

[mmollet · Accepted solution]

for the text property of your Approvers Name enter this formula:

If(Value(DataCardValue10.Text) > 10000, User().FullName, "")

If you want to hide a control until the number is above 10000 then use this formula in the visible property of that control:

If(Value(DataCardValue10.Text) > 10000, true, false);

This will input the currently logged in users full name into the text box if the value in datacardvalue10 text input is greater than (not equal to tho) 10000. You have to use the value function as anything entered into a text box defaults to a string. This will take the string value that was entered (if it is all numbers) and convert it into a number value that can be compared to 10000. If you dont use value function is will compare a string to a number and you will get errors and unexpected results.

Also im not sure if you are actually typing the "=" in the formula but if you are you need to remove that.

Hopefully this helps. If not can you post the error message and a screenshot of what you are trying to do so we can better help you?

[Olijk]

Hello,

Single

[Olijk]

Thank you so much!  It worked!

[Olijk]

I have a another question..

Is there a way to us an upload excel template to populate a +New item in an Sharepoint online list?  When I have 2 or more accounts to add at one time, I would like to be able to upload an excel file that would fill out the +New item from for me and total specific dollar amount fields.  Also, I would need to add 8 levels of approvers on the back end, but that is moreso going into Power Automate. Attached is sample spreadsheet, which will have more columns.

[Drrickryp]

@Olijk 

If you have a new question, make a new post.

[Olijk]

I did on another chat.  Thank you!