web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Rename Column in neste...

Power Apps

Answered

Rename Column in nested collection

(0) Share

Report

Report

Posted on by christian12

204

Hi Guys,

How do I rename a column within a nested collection.

Example collection A, has a nested collection within column header age.

I want to change the column value within Collection A nested collection Age column Result to Output

RenameColumns(A,Age ,"Result ", "Output")

Tried this although does not work.

Any help is greatly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @christian12 ,

I assume there is a collection:

ClearCollect( A, {Id:1,Age:Table({Result:"1"})}, {Id:2,Age:Table({Result:"1"},{Result:"2"})} );

You could use this formula to rename the 'Result' to 'Output':

GroupBy(RenameColumns(Ungroup(A,"Age"),"Result","Output"),"Id","Age")

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation