Create a collection based in values in one column

(0) Share

Report

Posted on by EmilioRoqueta69

565

Hi,

I have a table in dataverse that contains a string column called "IDHardware", by example:

IDHardware

1:4:7

With 3 or more values separated with ":" or "," (it is the same for me)

How can I create a collection like:

collectionIDHardware

With one row for each value or the column.

I need to use a Lookup to retrieve the value of this column, and the what else?

Thanks in advance,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@EmilioRoqueta69 one method:

ClearCollect( collectionIDHardware, Ungroup( ForAll( 'Your Data', Split( 'Single line text column', ";" ) ), "Value" ) )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like (0)

Report

Thanks Amik,

I have some issues with this formula, I think the Ungroup is not working because the value of the lookup column is not a table.
I share my formula and the example of the column.
If you are so kind and take a look please. Thank you very much!

Was this reply helpful? Yes No
Verified answer

timl 36,387 Super User 2025 Season 2 on at

Like (1)

Report
Hi @EmilioRoqueta69

It looks like you want to do this for a single record only - the one where the ID matches the value of lbllastIDHardware. If that's the case, you can try this:

ClearCollect( colMyItemsHard, Split(LookUp(tbd_HardwareRequests, ID=lbllastIDHardware.Text), ":" ) )

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like (0)

Report

Yes!
It is works! Thank you both

ClearCollect(
colMyItemsHard,
Split(LookUp(tbd_HardwareRequests, ID=lblLastIDHardware.Text).Hardware,":")
);

Was this reply helpful? Yes No