Answered

Using ShowColumns & RenameColumns within ClearCollect

(0) Share

Report

Posted on by hitty

Hi so I have a couple galleries (Seen Below) and I was wondering if it was possible to use ShowColumns and RenameColumns within the same Clear collect. I am just trying to see if I can cut down on the amount of collections built of the same data.

ClearCollect(
galCollect,
ShowColumns(hidden_all_your_taskers_gallery.AllItems,"Title","Users_That_Submitted","Status")
);

and

ClearCollect(
myTheory,
RenameColumns(
galCollect,
"Title","coll_Title",
"Users_That_Submitted","coll_Users_That_Submitted",
"Status","coll_Status"
)
);

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@hitty

Yes, Please consider changing your Formula to the following:

ClearCollect( myTheory, RenameColumns( ShowColumns(hidden_all_your_taskers_gallery.AllItems,"Title","Users_That_Submitted","Status"), "Title","coll_Title", "Users_That_Submitted","coll_Users_That_Submitted", "Status","coll_Status" ) ) )

I hope this is helpful for you.
hitty 28 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you, I knew I had the syntax wrong!
hitty 28 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Could I add Ungroup into this along with show columns? My "Users_That_Submitted" is a nested table so I have been un grouping it into a separate collection after. Is it possible to do that within the same set of code?

So Un