Get record owner name

(1) Share

Report

Posted on by JW-02052039-0

Hi there -I've set up a flow that creates rows in a table, based on changes in a BPF. My only difficulty is getting the record owner name. The BPF is active on the ko_deals object. Every ko_deal has a record owner. I can only access Owner id from the ko_deals table so I need to connect another table using the owner id in order to get the Owner name.

I've tried connecting, Owning User and Users, but neither work.

All responses (5)

Answers (1)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Get record owner name

Hi Partner,

Based on the error message:

It should be that the user you want to put in owner lacks the necessary permissions to the 'Application status history' table.

1.You need find the user based on id--fbd146cb-ad79-ee11-8179-000d3a0a2476

2.You need assign sufficient privileges on this table(Application status history) on any security roles that has assigned to this user.

https://learn.microsoft.com/en-us/power-platform/admin/security-roles-privileges
I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah
Verified answer

JW-02052039-0 29 on at

Like (0)

Report

Get record owner name

this is the error I get when simply adding Owning user to that syntax:

Read Privilege Check For Owner failed with exception: Principal user (Id=fbd146cb-ad79-ee11-8179-000d3a0a2476, type=8, roleCount=6, privilegeCount=918, accessMode='0 Read-Write', AADObjectId='4c74db78-c1fb-49fa-a1b2-8108a1223c47', MetadataCachePrivilegesCount=8583, businessUnitId=fe92a2d7-c659-ee11-8df0-000d3af41d60), is missing prvReadcr968_newtable privilege (Id=f5201050-f718-4d55-9f09-2d478893b11a) on OTC=11146 for entity 'cr968_newtable' (LocalizedName='Application Status History') in Business Unit: Guiker (Id=fe92a2d7-c659-ee11-8df0-000d3af41d60). context.Caller=14b1f35b-e75a-ee11-8df0-000d3a0a2b77. Consider adding missed privilege to one of the principal (user/team) roles.

I get the same error when I first join the Users table and assign User unique identifier in that field. What privileges am I missing?
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Get record owner name

Hi Partner,

If you want to set owner value in the power automate, you should use the correct formatting and user id:

systemusers(user id)

You can use owner value from another records directly:
JW-02052039-0 29 on at

Like (0)

Report

Get record owner name

I have tried connecting Users but the flow errors on every run when assigning this value into the Owner Field.
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Get record owner name

Hi Partner,

You can try to select ‘Users’ table in the flow, Like this:

The Owner column is one special lookup column, it can be populated with user or team.

Therefore, you can select users or teams based on the type of actual owner of your records, but it is not possible to select "owners" in the flow.

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah