cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Mario1
Level: Powered On

Send ComboBox & dropdown values to SQL

I have a multi-select combo box and a dropdown that I want to use to insert records into a SQL table. I need users to be able to select multiple customer names and select one group then insert each into another SQL table. 

Example of Data:

Customers SQL Table:

CustomerID | CustomerName

1                  | XYZ Corp

5                  | Dallas Corp

10                | Hway

7                  | Town Corp

 

Group SQL Table:

GroupID | GroupName

8             | Top Tier

9             | 2nd Tier

 

Dropdown is called "Group" and displays a list of group names from Group SQL data source.

Multi-select ComboBox is called "Customers" and displays a list of customer names from Customer SQL data source.

 

Need to click a button and insert new records in another SQL table called "Customer Group Map" based on the values selected from the Customer ComboBox and Group DropDown.

Example data:

Customer Group Map

GroupID | CustomerID

8            | 1

8            | 5

9            | 10

9            | 7

9            | 5

 

Any guidance is appreciated

3 REPLIES 3
rgparisoto
Level: Powered On

Re: Send ComboBox & dropdown values to SQL

Hi @Mario1 !

 

Have you tested the Patch Function?

 

Regards,

 

Robson.

Mario1
Level: Powered On

Re: Send ComboBox & dropdown values to SQL

Yes I have researched the patch function but found no guidance on how to pull combobox multi-select data in as individual records along with the dropdown value.

rgparisoto
Level: Powered On

Re: Send ComboBox & dropdown values to SQL

You're right, I never have used something like these. If I find something I'll tell you.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 293 members 3,090 guests
Please welcome our newest community members: