Unanswered

Different edit permissions to edit form per user for Sharepoint list

(0) Share

Report

Posted on by powerpowerApps

Hi,

I'm working on an app where I want to give users access to edit one or multiple fields in a form (linked to a SP list) depending on their name.
Users in group A can edit only one field and the rest are view only.
Users in group B can edit many fields.

How can add two different form edit screens?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

BCLS776 8,994 Moderator on at

Like (1)

Report
Copy link

Link copied!

It's not necessary to have two different form screens for different user permissions. Instead, manipulate the DisplayMode of individual cards in the form using a global variable. Cards' DisplayMode is usually set to Parent.Default to match the form, but you can alter it.

In the OnStart of the app, Set() a variable depending on something such as membership in a MS 365 Group, a Lookup() in a SharePoint list, or some other way of distinguishing users.

Was this reply helpful? Yes No
GarethPrisk 2,828 on at

Like (1)

Report
Copy link

Link copied!
Friendly FYI that user's will still be able to navigate directly to the SharePoint list. You cannot control access to the individual fields/columns.

That being said, you can accomplish this a few ways:

Develop Two Apps

Share the apps to the appropriate users

Each app would be explicit to the group

This is helpful if there's multiple differences and may make it easier to maintain

Develop One App

Determine the user's group

Based on group, route them to screens for their purposes

Each screen can have a form with only the fields they need

A more involved way:

http://www.idubbs.com/blog/2019/using-powerapps-to-solve-sharepoints-column-level-security-puzzle/

Was this reply helpful? Yes No