I have created SharePoint form in Power Apps. The form includes a dropdown box based off a SharePoint choice column (we will call this dropdown box “Access Type”). The Access Type dropdown box has two choices, “Global BU” and “Entity Local”. Depending on the selected choice, a child dropdown box will become visible. So for example, if I select choice “Global BU” from the “Access Type” dropdown box, dropdown box A will appear. If I select choice “Entity Local” from the “Access Type” dropdown box, dropdown box B will appear.
If I select “Global BU” from the Access type dropdown box, and then select a value from dropdown box A, and then change my mind and select choice “Entity Local” from the Access Type dropdown box, any value already selected in dropdown box A will reset via the following formula (added to the Reset property in drop down box A):
This works fine in New Form Mode but does not work in Edit Mode on SharePoint. Data previously entered in dropdown box A still gets saved to SharePoint.
Could anyone advise a workaround?
Solved! Go to Solution.
Are Dropdown A's items and Dropdown B items SP columns?
What column type of them?Could you please share more details of your DropDownA and DropDownB?
You want the DropDownA and DropDownB to show based the Access Type's value?
And Access Type and DropDownA,DropDownB are all choice type columns in SP list?
You can test as this:
I appreciate your response but you have completely misread the question. The issue has nothing to do with conditionally making fields visible.
I am trying to reset/clear data previously saved to SharePoint if a user makes a change to a dropdown value in Edit Mode.
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications