Answered

Form Update throwing error with a collection (choice column put as Gallery with check box in the PowerApps form)

(0) Share

Report

Posted on by Christelle

Hi!

I am pretty much starting with Power Apps. I made a form linked with a SharePoint Item List. One column is a choice column. In Power Apps, I want people to click on check boxes to defines in which countries they work. So in the form, I put a Gallery based on the choices in the SP column (Items:

Choices([@DOAItemlist].DOAScope) ). Then in the Gallery I put a check box (Text: ThisItem.Value). On Check: Collect(ColDOAScope,ThisItem) and OnUncheck: RemoveIf(ColDOAScope,Value=ThisItem.Value)

I saw 2 videos that were telling to change the "update" property of the DataCard to the collection created. So I did it. But I get an error message, saying: "Issue: Expected Record Value. The property on this control expects Record values. The rule produces Table values which are incompatible... How to fix: Change the rule to produce a {0} value."

Why should I do?

P.S.: I have absolutely no IT background, so please use simple sentences and easy solutions 😉

Thanks a lot!

Christelle

Categories:

General Questions

All responses (10)

Answers (2)

CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Form Update throwing error with a collection (choice column put as Gallery with check box in the PowerApps form)

@Christelle Glad that it works!
Christelle on at

Like (0)

Report

Re: Form Update throwing error with a collection (choice column put as Gallery with check box in the PowerApps form)

I erase the datacard this morning and did it again new. It worked.
Verified answer

Christelle on at

Like (0)

Report

Re: Form Update throwing error with a collection (choice column put as Gallery with check box in the PowerApps form)

@CM

ok, I will try. But I am going to export my App before I try that as it cost me a lot of time to build my form with Office365.SearchUser that was difficult to use because of our entreprise email structures 🙂
CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Form Update throwing error with a collection (choice column put as Gallery with check box in the PowerApps form)

@Christelle The App is still looking to the old definition. You may have to remove the SP List from the Datasources in the App and add it again.
Christelle on at

Like (0)

Report

Re: Form Update throwing error with a collection (choice column put as Gallery with check box in the PowerApps form)

@CNT
Thanks for your help! I erase the Data Card and add the field again in my form. But the error is still here (and in Default, if I write ColDOAScope ...
CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Form Update throwing error with a collection (choice column put as Gallery with check box in the PowerApps form)

@Christelle The old App may not know the change you have made to the definition of the SP List. You may have to remove and re-add that field to the Form.
Christelle on at

Like (0)

Report

Re: Form Update throwing error with a collection (choice column put as Gallery with check box in the PowerApps form)

@CNT
I changed my column in SP to allow multiple choice, because I want all the answers checked in the App to be transcripted in the SP Item in the SP list. So I do not want to use First(ColDOAScope).
Still, with the possibility to have multiple choice in the SP column, the App does not accept the Collection ColDOAScope in the update properties.
In another App I created in a similar way, I do not get an error. And I cannot recognize any difference in the created elements.
Verified answer

CNT 10,919 Super User 2025 Season 1 on at

Like (1)

Report

Re: Form Update throwing error with a collection (choice column put as Gallery with check box in the PowerApps form)

@Christelle
It looks like this Choice column in the SP List is set to take only one value (Allow multiple selections is set to No). Is this what you want?
If yes, the Update property of the datacard expects a record and not a table (collection). So you have to decide which record in the gallery you want to save. For Example, is it is the first Item in your collection, you can say, First(ColDOAScope).
Christelle on at

Like (0)

Report

Re: Form Update throwing error with a collection (choice column put as Gallery with check box in the PowerApps form)

Hi!
And how can I do that? with concatenate? Concrete formulas are welcome 😉
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Re: Form Update throwing error with a collection (choice column put as Gallery with check box in the PowerApps form)

Hey! You are returning a full list/Collection.

It only wants 1 item from that list/collection