Granting access to rows to a an external user and all of their coworkers
When an external user creates a row, I'd like all external users (that the app has been shared with) to have access to that row. For example, when firstname.lastname@example.org creates a row, no one else should have read access, except for any other user with an othercompany.com address.
And this needs to be security, not just hiding rows via a PowerApps filter (as the user would still have access to the SharePoint list).
I could create a sharepoint group for each external company, keep the group up to date, and use a flow to assign permission to the group. That's a lot of extra admin overhead though.
I don't know much about power apps portals, but perhaps there are additional options there? I could configure a filter so that only matching rows appeared, but the filter options seem to be limited, in that filters seem to need to have a hard-coded value. Is there a way to filter it so that the filter returns rows where the currentrow.emaildomain = currentuser.emaildomain?
SQL would work, but the number of pro licenses to support all the external users would be a no-go.
You can restrict sharepoint list for users who created the records, so they can't see or modify any other user record but if you want to assign to group then you have to go to permission settings and row level setting which is definitely lot of work. Please see attached how you can restrict sharepoint list for the specific user.
Please Thumbs up if my post helped you solve your issue and accept it as the solution to help the other members find it