Hi,
I have a PowerApp that is using a Edit Form. It is pulling fields from a SharePoint file. One of the fields (Warranty Claim?) is a dropdown with 2 choices- Yes or No. I have 2 buttons at the bottom (Submit buttons). They each have different actions upon selecting. I want the appropriate button to be visible when the corresponding choice is made from that dropdown. I keep getting an error when trying the formula for the Visible control. Any suggestions?
Thank you.
Solved! Go to Solution.
What is the formula you have errors with?
In general, your Visible property of the button will be the following formula:
YourEditForm.Updates.WarrantyClaimColumn.Value = "Yes"
(or "No" depending on the button)
Replace names in the above formula based on your app names.
I hope this is helpful for you.
@RandyHayes Ah! I had reordered these two buttons to the back...
I moved them back to the front and now they work.
Thank you!
Is the Complaint Group column defined as multi-select in the list?
Your initial error seems to indicate that it is.
Although I don't typically recommend basing a formula off of a DataCardValue control, you could, in this case, use:
DataCardValue1.Selected.Value = "Defective Item"
for the Visible property.
What is the formula you have errors with?
In general, your Visible property of the button will be the following formula:
YourEditForm.Updates.WarrantyClaimColumn.Value = "Yes"
(or "No" depending on the button)
Replace names in the above formula based on your app names.
I hope this is helpful for you.
It worked like a charm. Thank you!
@RandyHayes , a follow up to this. Would this "cloaking" feature affect the OnSelect controls? When I play the app, nothing is happening when I click the revealed Button.
Button3=
Button2=
No, your formulas all have & in them. This is the concatenate text operator. Replace all of those with ; semicolons.
@RandyHayes I made that change, however the 2 buttons are not even able to be clicked (same as before this change). Nothing changes with my mouse pointer when I put it on the button (when visible), and the button is not changing colors like normal. I have a 3rd button on the page at the top for "Cancel" which simply resets the form when clicked. It responds when you hover over it with the mouse pointer. The only difference between the settings on these is the Visible formula. Thoughts?
What is your Visible property and what is your DisplayMode property for the buttons?
@RandyHayes Ah! I had reordered these two buttons to the back...
I moved them back to the front and now they work.
Thank you!
That was going to be my next question ... 😁
Glad you have it working now!
@RandyHayes Hi Randy. I decided to make a change on which dropdown box would govern the visibility and function of my Submit button, but now I am getting an error-
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
161 | |
91 | |
67 | |
63 | |
62 |
User | Count |
---|---|
216 | |
158 | |
96 | |
86 | |
79 |