Unanswered

Conditional Formatting for Visibility Not working for SharePoint Customize Form.

(1) Share

Report

Posted on by Trout19

395

I am Customizing a SharePoint List to take in Purchase Requests. I have the list to show/ hide fields based on buttons Pushes. The form works as expected inside power apps. On SharePoint I can create a new item as the form should be ,but once I press save, all the fields show that are supposed to be hidden.

Has Anyone had a similar issue?

Here is what it looks like after Pressing Save

What it should look like after pressing save.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi Trout19

What is the condition you are using the hide the elements and where/how do you set it ?

Was this reply helpful? Yes No
Trout19 395 on at

Like (0)

Report
Ok, I am putting this code in the visibility property of the DataCard that it field is in.

If(StatusValue.Text = "Reviews",true)

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

So is StatusValue a Classic Text control and when and how do set the value on this ?

Was this reply helpful? Yes No
Trout19 395 on at

Like (0)

Report

Ok the StatusValue text property is set by a variable. Which is created on the OnNew button of the form.

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Sorry, but I am unclear here - if the Visible
If(StatusValue.Text = "Reviews", true)

then it should only be visible if the variable varStatus equals "Reviews", but you are setting it OnNew to "New", which means (based on what you have posted) the fields should be hidden from the start. You must be setting it to "Reviews" somewhere for it to be visible. - you need to set it to something other than "Reviews" OnSuccess of the form. Also do not bother with the text control - just refer directly to the variable - try making the Visible (just this)
varStatus = "Reviews"

Was this reply helpful? Yes No
Trout19 395 on at

Like (0)

Report

The status is changed by the complete button.

I changed the Visibility to if (varStatus = "Reviews", true). The visibility is still not working. It's like the Save Button overwrites the visibility of the form. The show/hide visibility is working when I use the complete button in power apps, but I don't have the built-in save button to test with.

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
This is a logic exercise that I need you to have a think about as I cannot see your model or code. Firstly, make the Visible as I posted
varStatus = "Reviews"

Also if the Complete button sets the Variable to this value, then it will be visible, so where do you set it to something else to make it not visible ? I assume also that you do not set varStatus using UpdateContext somewhere.

Was this reply helpful? Yes No