Answered

Patch issues combobox

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

Unfortunately it is not possible to select multiple values in a dropdown control. However I have tried to use combo boxes to multi select options. Now I have come accross a problem that I cannot solve and I have wandered around the forums a lot lately.

In essence I am trying to make an advanced form which people can fill in and which is saved to a sharepoint list database. Patching single select dropdown controls have not been a problem for me with this type of syntax:

Country(Column name in SP list):{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:1,
Value:DrpCountry(dropdown control).Selected.Value}

However if I would for example ask to which countries someone has been in the last year I want them to pick multiple options. Combobox offers this multiple selection but if I try to use the patch syntax for this it won't create a new entry in the Sp list. It gives an unknown error.

Anyone got better ideas on how to patch multiple selections in a new entry on a sharepoint list? I would be glad to hear so.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

Could you please share a bit more about your app's configuration?

Further, could you please show a bit more about the Country column in your SP list? Is it a Choice type column which has allowed multiple selections?

I assume that Country column is a Choice type column in your SP list, which has allowed multiple selections. I have made a test on my side, please take a try with the following workaround:

Set the OnChange property of the Combo box control (On my side, it is DataCardValue3) to following formula:

Clear(CountryTable);
ForAll(
DataCardValue3.SelectedItems,
Collect(
CountryTable,
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:CountRows(CountryTable),
Value:Value
}
)
)

Set the OnSelect property of the "Submit" button to following formula:

Patch(
'20180720_case6',
Defaults('20180720_case6'),
{
Title:DataCardValue1.Text,
EmployeeName:DataCardValue2.Text,
Country:CountryTable
}
)

Note: The '20180720_case6' represents the SP list data source within my app. The Country is a Choice type column in my SP list , which allows multiple selections.

The GIF image as below:

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

That helped a lot. Thankyou Kris!

Was this reply helpful? Yes No
jharville1 183 on at

Like (0)

Report
Copy link

Link copied!

Where did you initially create the CountryTable?

Was this reply helpful? Yes No