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

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

rzuber 545 Moderator on at

Like (0)

Report
Collect(colAddUsers, Patch(ThisItem, {Access: "Edit"}))

Was this reply helpful? Yes No
FunkyStuntMunky 8 on at

Like (0)

Report

Awesome. Thanks for the quick reply. Just what I needed.

Was this reply helpful? Yes No
rzuber 545 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation