cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaina
Resolver II
Resolver II

Multiple Selection Dropdown field Customize Form using SharePoint List

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 

 

jaina_0-1621914063081.png

jaina_1-1621914099047.png

 

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

 

Kindly help. Thank you.

 

1 ACCEPTED SOLUTION

Accepted Solutions

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.

v-albai-msft_0-1621925699384.png

Best regards,

Allen

 

View solution in original post

10 REPLIES 10
rizkyaditya
Resolver III
Resolver III

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!

jaina
Resolver II
Resolver II

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

 

jaina_0-1621919707708.png

jaina_2-1621919738996.png

 

jaina_1-1621919722937.png

 

jaina_4-1621919961452.png

 

 

@jaina 

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

jaina
Resolver II
Resolver II

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

@jaina 

 

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

yourComboBoxName.SelectedItems

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.

v-albai-msft_0-1621924285300.png

 

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

v-albai-msft_1-1621924414606.png

Best regards,

Allen

jaina
Resolver II
Resolver II

yes

 

jaina_0-1621924555260.png

 

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.

v-albai-msft_0-1621925699384.png

Best regards,

Allen

 

@v-albai-msft 

So does on my side, nothing shows any error.

Maybe the suggestion from Allen can be your solution @jaina .

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,595)