Clearcollect from gallery

(0) Share

Report

Posted on by R Bakker

725

Hi everyone

I have a numerical collection like 1,4,2,3 that I concat and then Patch to a record in a database, like so, ProcedurePPE:Concat(PPEID,Value,",") but I don't know how to clearcollect it back into my PPEID collection when I select that record in the gallery.

I tried forall and many other things but they did not work.

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

timl 36,740 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Corissandageri

It looks like you're storing a comma-separated list of values in your database. Therefore, you can reconstruct the collection by calling the Split function.

ClearCollect(PPEID, Split(Gallery1.Selected.ProcedurePPE, "," ) )

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Hi timl
Your formula works if I change the collection name, but does not like it if I use it under the original collection name. Almost like it's a different data type. Below is how I am collecting the original collection.
If(!(ThisItem.ID in PPEID),Collect(PPEID,ThisItem.ID))

Was this reply helpful? Yes No
timl 36,740 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

After you collect PPEID with the original formula, if you go to the Collections panel and inspect the contents, can you post a screenshot or post the column header names of PPEID?

Was this reply helpful? Yes No
Verified answer

R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!
Hi timl
You were right I was collecting as a Values, then concat the values and saving in to a text column. So
ClearCollect(PPEID, Split(Gallery1.Selected.ProcedurePPE, "," ) )
This works if I collect from a text column.
Thank you again

Was this reply helpful? Yes No