Unanswered

Save data in a collection

(0) Share

Report

Posted on by Community Power Pla...

Hi all!

Im triying to save specific values in a collection, yesterday was working porpertly but today at the moment to save the same values nothing happens and the collection still empty, im using the next formula:

ForAll(
 Gallery7.AllItems;
 Collect(
 Evaluacion;
 {
 Categoria: Label9.Text;
 Topico: Title5.Text;
 Calificacion: Slider3.Value
 }
 )
)

When this was working the values were saved in the collection and then exported in a excel file via Power Automate:

So today im triying to save the same values in the collection but isnt working

This is how the app looks rigth now

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@Anonymous

Your formula is backward and you are wasting the output of your ForAll.

Consider the following change:

Collect(Evaluacion; ForAll(Gallery7.AllItems; { Categoria: Label9.Text; Topico: Title5.Text; Calificacion: Slider3.Value } ) )

See if that is helpful and if not, let me know what the results are and we can proceed from there.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi! @RandyHayes

I tried the suggest change but still not working,

Also tried to create a new collection to discart that "Evaluacion" collection was corrupted but it doesnt work too.

Yesterday I used the format provided by x-vida-msft on this post and applied to my app and works

https://powerusers.microsoft.com/t5/Building-Power-Apps/Save-data-from-Gallery-in-collection/td-p/390556

And also if i remove the "ForAll" formula works again, but only save one records instead the 35 need it

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

So technically the formula I provided should work for you.

But I am seeing some discrepancy in your pictures.

You show a gallery with califcacions of 5. You then show a collection with 5 in it. You then show an Excel file with 2 in it.

Perhaps this is a clue as to something going wrong?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@RandyHayes

I used an old file as reference to show that is only saving one record.

Let me check all the things on the screen to see if there's anormally affecting the formula.

Was this reply helpful? Yes No