I have a table "Books" in which I have the data about the books that I have read. I have implemented "User" level security for this table so, only the owner of the record can have access to this record in Canvas Power Apps.
Now I want to add a toggle to switch this record to public so, everyone in the organization can see that I have read this book. Is it possible then how.
NOTE: The number of people in the organization can be in thousands.
Hello,
if idea is that if all users should be able to read these books records, then why not have base role which gives user permission to read organization wide records and assign this role to team where all user belongs (it could be Azure AD group as well)..
if requirement is for only specific records to be shared with teams and not others then I guess dynamics have access team feature which can be used for this... refer more details here.. https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/sample-share-record-using-access-team?view=op-9-1
Hi @dpoggemann
I get the idea and sounds good idea. I will wait for sometime if someone has a better idea if not than I will accept your answer as solution.
Hi @Usmannb ,
I haven't specifically done this but you could have a team that is tied to an Azure Active Directory security group and have this team be basically your full organization. You could then call a flow from your Power App or even set a column on the record that will trigger the flow to perform an unbound action and share the record with the team.
https://onlinemgblog.wordpress.com/2020/07/20/power-automate-share-record-using-unbound-action/
Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
stampcoin
15
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1