Multiple Selection Dropdown field Customize Form using SharePoint List

(0) Share

Report

Posted on by jaina

517

Hi,

Can you help, i have a created a customize form connected to a SharePoint List.

Now, I have a Config Plant (Dropdown Selection), and I set it up as multiple selection. In my power app, I can select multiple but the problem is I encountered error in Default property

I guess, this is the reason why the data I have selected doesn't reflect in my sharepoint list.

Kindly help. Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

rizkyaditya 292 on at

Like (0)

Report
Copy link

Link copied!
Hello @jaina ,

You can try this :

1. Default property for your Datacard :
ThisItem.'Config Plant'

2. Items property of your ComboBox used for selection (i assume you use combobox, because i dont think dropdown can hold multiple value selection) :
Choices(yourListName.'Config Plant')

3. And just double check that your ComboBox DefaultSelectedItems property is set to : Parent.Default

It should patch whatever your selections are to your list, and also read them back to the ComboBox.
I hope this helps!

Was this reply helpful? Yes No
jaina 517 on at

Like (0)

Report
Copy link

Link copied!

Hi @rizkyaditya , all formula you mentioned has the same set up in my power apps with encountered error..

Was this reply helpful? Yes No
rizkyaditya 292 on at

Like (0)

Report
Copy link

Link copied!

@jaina
Can you share what kind of error message that you get?

Was this reply helpful? Yes No
jaina 517 on at

Like (0)

Report
Copy link

Link copied!

I tried to submit an with multiple entry in Config Plant but unfortunately, it only capture 1 item selected in SharePoint List and in Display

Was this reply helpful? Yes No
rizkyaditya 292 on at

Like (0)

Report
Copy link

Link copied!
@jaina

Have you set the Update property of your datacard to this ? :
yourComboBoxName.SelectedItems

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @jaina ,
Are you editing Default property on combo box or on its DataCard?
If you want to set a default value for combo box, just put code into DefaultSelectedItems property of this combo box, no need to edit Default property of this combo box, you can leave it blank.

Besides, since your combo box allows multiple selections, check if the Update property of your DataCard is set to formula like below(.SelectedItems returns a table, .Selected returns a record😞
DataCardValue.SelectedItems
Best regards,
Allen

Was this reply helpful? Yes No
jaina 517 on at

Like (0)

Report
Copy link

Link copied!

yes

Was this reply helpful? Yes No
Verified answer

v-albai-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @jaina ,
Have you done any custom settings for this DataCard or for this combo box inside your app?
All your settings appear to be correct, and these formula are all gengrated by default(seems that there is no any custom setting).
I did a test on my side with all the configurations you provided(except column name), everything works fine on my side when submitting a new list item with multiple selections. So I would suggest you remove this DataCard and re-add this column again for your SharePointForm1(this is the default name for the SharePoint customize form), check if you can submit list items successfully this time.
Best regards,
Allen

Was this reply helpful? Yes No
rizkyaditya 292 on at

Like (1)

Report
Copy link

Link copied!

@v-albai-msft
So does on my side, nothing shows any error.
Maybe the suggestion from Allen can be your solution @jaina .

Was this reply helpful? Yes No
jaina 517 on at

Like (0)

Report
Copy link

Link copied!

Hi @rizkyaditya @v-albai-msft ,

This is okay now. I just add new combo box field and it works fine now in power apps.

Just wondering why power apps did not capture the changes made with the previous field. Actually, the initial field is not a combobox but rather a dropdown field. I just change it to combo box in sharepoint list. I removed the datacard and re-add it to capture changes in power apps but failed.

So, i just created a new field (combo box), its just that this is not a best solution since there are data already in the previous field.

Was this reply helpful? Yes No