Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Making a record public or private on demand in Dataverse?

(0) ShareShare
ReportReport
Posted on by 63

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.

  • MayankP Profile Picture
    462 on at
    Re: Making a record public or private on demand in Dataverse?

    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

     

     

     

  • Usmannb Profile Picture
    63 on at
    Re: Making a record public or private on demand in Dataverse?

    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.

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on at
    Re: Making a record public or private on demand in Dataverse?

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 15

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics