Collection strange behavior Value vs Result

(0) Share

Report

Posted on by emfuentes27

578

I have a gallery with checkboxes in it. I collect the selected values and add them to a collection:

Checkbox

onCheck: Collect(multiStates, ThisItem)
onUncheck: Remove(multiStates, ThisItem)

Then I have a textbox where I add the collection using Concat:

Default:Concat(Sort(multiStates, Value), Value, ", ")

This is a the issue. Once in a while this fails, because for some strange reason I need to change it to Result instead of Value:

//Using Value
Concat(Sort(multiStates, Value), Value, ", ")
//Using Result
Concat(Sort(multiStates, Result), Result, ", ")

This happens just randomly:

Screenshot 2022-08-19 083251.png

After working just fine for about a month, at this moment is using value, but a few weeks from now for no reason at all (that I know of), without making any changes anywhere, I have to go back and change the Concat function to using Result. Has anyone seen this behavior before? I'm leaning towards to creating a function to check if Result or Value are empty, and then right one, but I'm not sure how to accomplish this.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @emfuentes27 ,

Have any changes been made to the app or the data source while you are having this issue?

Was this reply helpful? Yes No
emfuentes27 578 on at

Like (0)

Report

Thanks @BCBuizer . As I mentioned, no changes has been made. As a matter of fact I just returned to the office today, and I was told by the users of the app that they were unable to use the form. I'm the only one that can make any changes to the code or the data source. This has been happening for about 6 months now, so I just got tired of changing it back and forth between Result/Value.

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @emfuentes27 ,

Not sure if this is throwing any errors, like "identifier not recognized", but as a workaround you may consider the below:

IfError( Concat(Sort(multiStates, Value), Value, ", "), Concat(Sort(multiStates, Result), Result, ", ") )

Was this reply helpful? Yes No
emfuentes27 578 on at

Like (1)

Report

That should work. I was not aware of IfError. Thanks.

Was this reply helpful? Yes No