web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Granting user access t...

Power Automate

Answered

Granting user access to its own row in dataverse table

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

We want to automatically grant office users access (read and write) to their own dataverse row. So the office user should be assigned to own the row of the table, which corresponds to their name. How is the code for the unbound action, grantaccess?

The picture shows that we have one entry which is the full name on the left and we want to automatically assign the user that corresponds to this full name.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :

Do you want to replace Ower in the table with the value in the FullName field? Something like:

to

If so,I've made a test for your reference:

1\Create a canvas and add Users and Your Data table as datasource:

2\Add a button and set it's OnSelect property to:

ClearCollect(TheSource,Homes.Home); /*Homes is my custom table*/ /*Home is the Guid column*/ ForAll(TheSource, Patch( Homes, LookUp(Homes,Home = TheSource[@Home]), {Owner:LookUp(Users,'Full Name' = LookUp(Homes,Home = TheSource[@Home]).Name)} ))

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft,
thank you for your answer. That is exactly what i mean, but I do not want a button On Select property to do it, but automatically within a flow. Any suggestions?

Was this reply helpful? Yes No

Join the conversation