web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Ungroup a table within...

Power Apps

Answered

Ungroup a table within a collection to a new collection

(0) Share

Report

Report

Posted on by TB-20081424-0

220

Hi, I have a collection which is composed of a group of items from a Sharepoint list. The items in the Sharepoint list are grouped by "Title" and the group is called "AppDATA".

Gallery item property is the group . On checkbox the item selected is put into a collection. See image.

My question is how do I Ungroup this table of records so that I can update and patch to the Sharepoint list?

Each time I try to do Ungroup... I get an error that a column name already exists.

Here is my code for the ungroup:

ClearCollect(collectTOBEAPPROVEDUngrouped, Ungroup(collectTOBEAPPROVED,"AppDATA"));

here is the error:

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TB05 ,

This is because you already have a column named 'Approver'.

So please try this formula:

ClearCollect(collectTOBEAPPROVEDUngrouped, Ungroup(RenameColumns(collectTOBEAPPROVED,"Approver","Approver1"),"AppDATA"));

Best Regards,

Wearsky

Join the conversation