CODEWITHSUNDEEP
excelpowerappssharepoint-list
VeeEss
VeeEss

Reputation: 33

How do I save combo-box values to a SharePoint list?

I have a Power App where users input a serial number. I have 1 text-box and 3 combo-boxes that depend on the serial number input by the user. The lookup table is in Excel. It is working and able to do lookup.

However, I need to be able to record the data in a SharePoint list. The text-box is recorded properly, but the values of the combo-boxes are not.

In short... Power App > User input serial > Lookup excel table for 4 attributes of the serial > user clicks submit in the power app > power app records data in Sharepoint list > power automate flow sends email notification.

Upvotes: 0

Views: 1580

Answers (1)

Ashish Goel
Ashish Goel

Reputation: 31

Use Patch function like this

Patch('DataSouceName', Defaults('DataSouceName'), {Title: TextInput1.Text, Comboboxfield: {Value: Combobox1.Selected.Value}})

Here, Combobox1 is the name of the combo box and Comboboxfield is the name of the column where you need to store the combo box selected value.

For more info on Power Apps visit the following website: http://ashishcoder.com/courses/power-apps/topics-list.html

Thank you

Upvotes: 1

Related Questions