cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Reset dropdown box value based on another dropdown box in Edit Mode on SharePoint

Context:

 

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.

 

Issue:

 

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):

 

Not(Find(ACCESSTYPE.Selected.Value,"Global BU")>0)

 

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Helper I
Helper I

Re: Reset dropdown box value based on another dropdown box in Edit Mode on SharePoint

6 REPLIES 6
Highlighted
Community Support
Community Support

Re: Reset dropdown box based on another dropdown box in Edit Mode

Hi @imranamikhan 

 

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?

 

Best Regards.

Yumia 

Highlighted
Helper I
Helper I

Re: Reset dropdown box based on another dropdown box in Edit Mode

Hi Yumia - Yes Dropdown A and Dropdown B are SP choice columns. Although the columns are different, they do contain the same choices .

Highlighted
Helper I
Helper I

Re: Reset dropdown box based on another dropdown box in Edit Mode

Hi everyone - if anyone else could help that would be appreciated.

Highlighted
Community Support
Community Support

Re: Reset dropdown box based on another dropdown box in Edit Mode

Hi @imranamikhan 

 

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:

visible&value.gif

 

Best Regards.

Yumia

Highlighted
Helper I
Helper I

Re: Reset dropdown box based on another dropdown box in Edit Mode

Hello,

 

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.

 

Best regards,

Helper I
Helper I

Re: Reset dropdown box value based on another dropdown box in Edit Mode on SharePoint

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,914)