web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Collect a list of inte...

Power Apps

Answered

Collect a list of integers in the ID column of a collection

(1) Share

Report

Report

Posted on by Jedediah

183

Hello,

I'm struggling a bit to store a list of integer in the "ID" column of a collection.

I have a flow that returns a list of integers as a string : "1,2,3".

I want to store those integers in a collection which as one column and I want this column to be named "ID".

This formula gives me the expected result :

ClearCollect(test;[1;2;3])

But the column name is then "Value".

I want the same result, but with a unique column named "ID".

I know it is pretty simple but I can't find the correct way to do it.

Thank you 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!
Hey @Jedediah ,

try this:

ClearCollect(test;{ID:1};{ID:2};{ID:3})

Here's the way to do it directly with the string of integers:
Clear(test);; ForAll(Split(StringFormFLOW;",");Collect(text;{ID:ThisRecord.Value}))

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

Like (3)

Report
Copy link

Link copied!
Hi @Jedediah

If you've already built your collection, another option is to rename Value to ID like so:

ClearCollect(test; RenameColumns([1;2;3];Value; ID)) )

Was this reply helpful? Yes No
Jedediah 183 on at

Like (1)

Report
Copy link

Link copied!
Hey @DBO_DV and @timl !

Thank you for helping me to figure this thing out.

Here is the working code :
UpdateContext({locSplittedItems:'myFlow'.Run(First(myCollection).ID).items});; Clear(myCollection);; ForAll(Split(locSplittedItems;",");Collect(myCollection;{ID:Value(ThisRecord.Value)}))

Was this reply helpful? Yes No

Join the conversation