cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SK22
Regular Visitor

Unselect default value in combobox based on dropdown (sql connection)

Hi all,

 

I have a canvas app with a SQL connection. The create and edit controls are placed on one screen and the visibility of the controls is handled by a variable. 

 

Issue

I have a combobox named cmboOwner. This combobox depends on the selections made in dropdowns A and B (dropdown B depends on the value selected in dropdown A). When a user is in edit mode, existing data (=OwnerName) for a specific record is shown in cmboOwner. When a different value is selected in B, I want the default value in the cmboOwner to be "unselected" because the possible OwnerNames differ per value selected in B (so, in this case the pre-selected value shown in cmboOwner is incorrect, but the correct values are shown when expanding the dropdown). I've been at this for a few days with no success. How can I get the default value to get unselected when a different value is picked in dropdown B while being in edit mode? Is this possible?

Combobox:

  • Reset: cmboReset
  • DefaultSelectedItems: If(actionType="Edit",[(OwnerName)],[""])
  • Items: I'm using SortByColumns & Filter to retrieve data based on dropdown A and B.

Dropdown B:

  • OnChange: UpdateContext({cmboReset:true}) - I had also tried setting this code in "OnSelect", but I was experiencing the same issue.

I hope this makes sense. Thank you for your time.

0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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