Answered

Add nth column in Collection data

(0) Share

Report

Posted on by CookieNamtarn

Hello everyone,

I want to add a column in collection.

currently , I'm using the collect function to add new column
-----------------------------------------------------------------

example:

Collect(

Customgallery,

{

item: CountRows(Customgallery),

detail: Char(RandBetween(67,94))

}

)

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

but now, I'd like to add an nth column with a single click.

I don't have idea to do it. Can anyone provide some suggestions?

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

AR-29081311-0 137 on at

Like (0)

Report
Copy link

Link copied!
Hi @CookieNamtarn ,

are you looking to add the number of rows in the dropdown (3) when "Ad nth" is selected?.

If so, try this out onSelect of your nth button:

// Assuming Dropdown1 is your dropdown control ForAll( Sequence(Dropdown1.Selected.Value), Collect( Customgallery, { item: CountRows(Customgallery), detail: Char(RandBetween(67,94)) } ) )

The Sequence function will repeat the collection function, by the number of times in the dropdown.

Hope this helps!

Aaron

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hey @CookieNamtarn

you can also try this example:

ForAll( Customgallery, Collect( Customgallery, { item: item, // Existing column detail: detail, // Existing column newColumn: "New Value" // New column with static value } ) )

This formula will iterate over each row in the Customgallery collection and add a new column named newColumn with a static value "New Value".

If you need to calculate the value for the new column based on existing data in each row, you would modify the formula accordingly. For example:

ForAll( Customgallery, Collect( Customgallery, { item: item, detail: detail, newColumn: item + Len(detail) // Example of a calculated value } ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No