cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CoStratify
Frequent Visitor

If SQL cell has value, default selected item in combobox equals the value in that row

Sorry my subject isn't very clear. 

 

To be a bit more clear...

I have a combo box that is looking up the AppName from a SQL table. The idea of selecting the AppName is that it will write that App's AppID to the column dependant on what has been selected.

 

The area I would appreciate help with is... I want the Combobox's defaultSelectedItem to show if the row already has an AppID assigned and therefore automatically shows the related AppName on the combobox. 

 

Please could you advise what I need to put in the DefaultSelectedItem box it would be greatly appreciated, as I'm truly stuck haha!

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
CoStratify
Frequent Visitor

I think I've worked it out by using a dropdown instead of a combobox.

I have put the following in the default section.

LookUp('Datasource', ThisItem.AppID = AppID, AppName)

 

View solution in original post

1 REPLY 1
CoStratify
Frequent Visitor

I think I've worked it out by using a dropdown instead of a combobox.

I have put the following in the default section.

LookUp('Datasource', ThisItem.AppID = AppID, AppName)

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,459)