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
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

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