cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaina
Helper V
Helper V

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
Helper V
Helper V

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
Helper V
Helper V

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
Helper V
Helper V

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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,559)