Hallo, I am working on an Powerapp where I create a row in a Dataverse table. For each row I create two groups in the "Team" table. Now the goal is that I share the created row with those two groups, one with read, the other with write permission. Is there a way to accomplish that with Powerapps using a Canvas App?
The only thing I have read so far, was to use a flow with the "perform unbound action".
Is there any other way to solve that?
Thank you for any help
Hi @benji-7 ,
Can you explain more the "For each row I create two groups in the "Team" table? Do you have two teams overall and for another table you want to be able to have one group with read permissions to all the records and another group have write permissions? Is this different per record or consistent for all records that you are creating?
If this is consistent for all records I would do the following:
If this isn't the situation, please explain more and I can try and help.
This is almost solved. In my other post I found the solution using append and append to access rights to handle the permissions for the child tables.
So for every row that I create in the parent table I create the two groups with one read, the other append to rights on that created row. That's how I then can assign users to the different groups. For me that's not a problem as I have sysadmin role and can create new groups in the teams table and then use relate, unrelate in the app to assign the users to the groups.
I want to accomplish that some of the other users are able to create rows in the parent table as well. But that would mean, that I have to give them permission to create access teams in the team table, right? I don't now if this is could be a security issue.
Is there any other solution?
Sorry @benji-7 ,
Sorry, not sure exactly what you are doing here exactly. Hopefully the following makes sense.
I am happy to jump on a call sometime to walk through this in more detail if you need. Maybe I am missing the situation here but I think we can accomplish your needs with the above.
Sorry for the confusion... maybe I over-complicate it 😅.
Maybe I make an example:
I want to realize a trip planner for our NGO in Germany who is sending different groups to different countries.
One or two of each group are the trip leaders, the others are supporting and are trip participants.
Let's say we send a group to Argentina and another group to Mexico.
I created the following tables:
Parent: General Trip Details
Child 1: Budget List
Child 2: Trip locations
These are the teams:
So far I managed that with creating two records in the teams table for each row that is created in the "General trip Details"parent table and assigned the users to the teams.
The only problem I now still have, is that I can't easily
Your suggestion in my view would work if I really only have two teams that can access all the trips.
Thank you so much for looking into that. I really appreciate that!
Hi @benji-7 ,
Thank you for the example. Looking at your situation I would probably do the following type of setup in Dataverse. This is just an option you might want to review.
General Trip Details
The new table I am suggesting would have a lookup column to the User table and would also have a "Role" defined for Leader or Member.
Power Automate Flow (Assign Access Team Membership)
When members are added or removed from the Trip Members table, run a Power Automate flow that will assign or remove them from the specific Access Teams for the 3 tables. I think you would be able to utilize the bound actions for AddMemberRecordTeam and RemoveMemberRecordTeam in Power Automate but I have not looked at this in detail...
Overall the above approach would not require any maintenance as you add more trips etc. as the dynamic security for the members will be controlled at the record level based on the access teams they are assigned.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.