Default ThisItem error

[diegoandre10]

Hi all

I have a column called "Packaging supplier" on my SP list which is a choice datatype:

Soon after I enabled the "Allow multiple selections" the app showed the following error:

Can someone please help me identify the issue?

Thanks.

[BCLS776]

Yes, as soon as you allow multiple selections in a choice column, the column requires a record to work properly; it must be capable of storing more than one result. Treat the field as though it is its own column with the name Value within the Packaging supplier column.

If you want to see all the values in a single label, try: Concat('Packaging supplier', Value, ", ")

[diegoandre10]

Hi @BCLS776 

Where should I use that code?

Thanks.

[BCLS776 · Accepted solution]

That depends a bit on how you want your user interface to work. I noticed you have a dropdown on that card. If you want to keep using that, you could set the Default property of the card to: 

First(ThisItem.'Packaging supplier').Value

However, this displays only one value, not all of them.

You could use a label instead of the dropdown, in which case use a Default for the card of:

Concat(ThisItem.'Packaging supplier', Value, ", ")

This pastes all the choices together into a string, separated by commas

The best control to use for this is a combobox instead of a dropdown, in my opinion. If you use that, a few things to configure:

• Ensure SelectMultiple property is set to true
• Use Choices(mySPList.'Packaging supplier') for the Items property
• Put ThisItem.'Packaging supplier' in the DefaultSelectedItems property

Hope that helps,

Bryan

[diegoandre10]

Hi @BCLS776 

Just in case it's not a dropdown. It's a combo box from my SP list.

How should I proceed in that case then?

Thanks!

[diegoandre10]

Hi @BCLS776 

Please see how I have it:

The error persists on default:

What should I do?

Thanks once again!!

[BCLS776]

The Default property on the card should be OK, but the card is not yet recognizing the change to multiple selections for the column. Try two things to straighten this out:

1. Refresh the data source in the data listing for the app
2. If the problem persists, try removing and re-inserting that card only into your form

[diegoandre10]

Hi @BCLS776 

It worked with #2 !!

Thank you so much for your help!

Regards.

[rohitsbots]

After you change a existing field in sharepoint list to Multi-Select powerapps needs sometime to digest the change. No matter how much you refresh the datasource in your app it doesn't work. I faced this issue in customised form in a sharepoint list and for me the best solution has always been "Wait for 15-30 minutes" then reopen everything and then remove the existing cards and re-add them. It works like a charm!