web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Patching to dataverse

Power Apps

Answered

Patching to dataverse

(0) Share

Report

Report

Posted on by user391_

79

Hi,

I am trying to patch to the "out-of-the-box" users table.

This is my code :

Patch(Users, Defaults(Users), {'APM Group': drpGroupBS.Selected})

but this leaves me with an error that says "Field 'accessmode' is required" and I'm not sure what this means.

Any help would be appreciated,

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Jcook 7,783 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello @user391_

You can check the full list of "required" fields for the User table by:
- Going to the Tables tab under Dataverse.
- Selecting User table and click Columns.

Here are the docs for what each column is expecting.
User (SystemUser) table/entity reference (Microsoft Dataverse) - Power Apps | Microsoft Learn
For example, the Access Mode field expects an integer value for an option.
0 Read-Write
1 Administrative
2 Read
3 Support User
4 Non-interactive
5 Delegated Admin

What is your use case for wanting to add records to this table?

Was this reply helpful? Yes No
user391_ 79 on at

Like (0)

Report
Copy link

Link copied!

Hey so my solution was to use a lookup into the users email address instead of using defaults(users). I created a custom column within the users table, whcih I wanted to update

Was this reply helpful? Yes No

Join the conversation