Answered

How to patch data in System User Entity?

(0) Share

Report

Posted on by Dave Wi

Hello,

I have created a "CustomField1" in system user entity where I want to patch a data by user from the canvas app and I am using following formula against the System Users Collection:

Patch( Users, First( Filter( CollUsers, 'Primary Email' = User().Email ) ), { CustomField1: "Testing" } );

Above formula doesn't throw an error, at the same time, it's not patching value "Testing" into CustomField1 for the current user too.

Can you please share what is wrong here?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-jefferni on at

Like (0)

Report
Hi @dave8

Do you want to patch the CustomField1 to the User entity?

If you do, the Patch formula should be:

Patch( Users, First( Filter(Users, 'Primary Email' = User().Email )), { CustomField1: "Testing" }))

The Patch functions works in syntax like Patch( DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ]), the BaseRecord you want to modify should be in the data source.

You created a collection “CollUsers”, could you please share more details about your scenario? Collections collect one or many records form data sources, but store them temporarily. Modify a collection won’t affect the records in data source even if they are totally same.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Dave Wi on at

Like (0)

Report
Hi @v-jefferni

Thank you for your attention!

Do you want to patch the CustomField1 to the User entity? - Yes by individual user.

If you do, the Patch formula should be: - I have used the same formula as mentioned in the original post against Users Collection.However it's not working, I assume that's because records are more than 2000, and filter could work only on 2000 records at time?

Patch( Users, First( Filter(Users, 'Primary Email' = User().Email )), { CustomField1: "Testing" }))

The Patch functions works in syntax like Patch( DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ]), the BaseRecord you want to modify should be in the data source. - Yes, that's why I have applied the similar formula which is not working

You created a collection “CollUsers”, could you please share more details about your scenario? Collections collect one or many records form data sources, but store them temporarily. Modify a collection won’t affect the records in data source even if they are totally same. - There are more than 5000+ user records, I think I require to know how to filter large records - any clue? because when I filter records from first 2000, the same formula works, but not more than 2000 records that is what I am experiencing.

Thanks,

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report
Hi @dave8 ,

Since the Users entity contains more than 2000 records, there would be delegation issues with the function First() and the User().Email condition.

To avoid the delegation issue, create a global variable of user's email address with below formula on the log in or first screen.

Set(CurrentUserEmail,User().Email)

And the formula need to be modified to:

Patch( Users, LookUp(Users, 'Primary Email' = CurrentUserEmai), { CustomField1: "Testing" }))

Hope it helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Dave Wi on at

Like (0)

Report

Hi,

This is awesome, It worked for me the way I wanted 🙂

Thank you so much!

Regards

Was this reply helpful? Yes No