web

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

News and Announcements icon

Power Platform CommunityForums Power Apps add column to collecti...

Power Apps

Answered

add column to collection along with user record

(0) Share

Report

Report

Posted on by FunkyStuntMunky

8

HI, I am attempting to insert an additional column named "Access" into a collection when I add a user record from an Office365User search.

I tried this:

Concurrent(
Set(_selectedUser, ThisItem),
Reset(TextSearchBox2),
Collect(colAddUsers, ThisItem, {Access: "Edit"}))

but this adds it as a value on its own row, like this:

Thanks

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

rzuber 552 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Collect(colAddUsers, Patch(ThisItem, {Access: "Edit"}))
FunkyStuntMunky 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Awesome. Thanks for the quick reply. Just what I needed.
rzuber 552 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Happy to help!

The reason you experienced the behavior you did is because the Collect() function allows you to collect multiple records to a data-source at once. Each argument is expected to be a record that you wish to collect. In this case, we Patch() the first record with the intended data, thereby conforming the two records into one for the collection.

Collect, Clear, and ClearCollect functions - Power Platform | Microsoft Learn
Patch function - Power Platform | Microsoft Learn

Join the conversation