Update a row in Power Automate with name rather than value

(0) Share

Report

Posted on by dsammied

I need to be able to 'update a row' in power automate with the name (fullname) of the system user rather than the GUID, as for some reason these are different in the other environments. That is to update the 'Owner' of the entity form with a User, so the system is looking for the name rather than the guid. i.e Sarah Willis

All responses (2)

Answers (1)

dsammied on at

Like (0)

Report

RE: Update a row in Power Automate with name rather than value

That works!

Thank you :)
Verified answer

Community Member on at

Like (4)

Report

RE: Update a row in Power Automate with name rather than value

Hi dsammied,

No. However, you could list all User rows whose name equal Sarah Willis. Then update the row. Please follow the steps:

1. List all rows whose name equal the Sarah Willis

2. Check the length is 1 or not.

3.If yes, then update your row. Owner's expression: concat('systemusers(',first(outputs('List_rows')?['body/value']).systemuserid,')')

Test: