Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Patch to SQL- drop down & combo boxes

Hello All, I have a two for one question for you.


I am trying to patch a form to SQL but both my drop down selections and combo boxes are showing up as NULL. My drop down selections are defined within the app ["","",""] etc. I have tried the following functions:


2) 'lot_EMPLOYEENAME':EmployeeName.Selected

3) 'lot_EMPLOYEENAME':EmployeeName.SelectedText

4) 'lot_EMPLOYEENAME':EmployeeName.Selected.Value

5) 'lot_EMPLOYEENAME':Value(EmployeeName.Selected.Value)


The first try does not throw an error but it does not save. The other functions throw errors along the lines of "does not match the expected type" I have patched drop downs to SharePoint before but for some reason SQL is being a pain. Any advice on this? Thank you in advance


Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

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.

Users online (1,909)