Customer experience | Sales, Customer Insights,...

How to set lookup field as current user in a cloud flow using power apps

(0) Share

Report

Posted on by dev2143

Hi,

I have a field called approved by which is a lookup field. When the approve cloud flow is triggered it should set approved by to the current user, but I can't find away to select current user:

what do I select there?

If that helps, the approve cloud flow is triggered when a boolean is set to yes.

I tried googling it for 2 hours and I couldn't find an answer. Any help would be really appreciated.

Thank you

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Vipin J 1,603 on at

Like (0)

Report

user syntax like systemusers(Guid of current user)

Refer my blog: https://vjcity.blogspot.com/2019/11/moving-attachments-of-dynamic-365-crm.html

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

You will need to add List Rows to fetch User record based on Approved By Email Address -

Select 'Responses Approver email' from dynamic content in Filter rows.

Now you will select first record systemuserid from list rows and store it in variable -

Now use this variable to set your lookup field as below -

/systemusers(Variable from dynamics content)

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Updated Filter Rows Syntax -

internalemailaddress eq 'Responses Approver Email'

Thanks,

Bipin

Was this reply helpful? Yes No
Suggested answer

dev2143 30 on at

Like (1)

Report

Ok, so I managed to get it to work by combining the advice from the answers below with more info that I found online.

1) I get the current user email using Get My Profile (V2) (I couldn't get the responses from the answer below).

2) Create a List Rows and select the Users table. Then filter it using the email.

3) In Executive Summary Last updated, write /systemusers(@{first(outputs('List_rows')?['body/value'])?['systemuserid']}). @{first(outputs('List_rows')?['body/value'])?['systemuserid']} is a function that you can write in the function editor.

Was this reply helpful? Yes No
Suggested answer

Manoj Mane 1,020 on at

Like (0)

Report

Hi dev2143,

We can set the any lookup filed value in Power Automate as follow:-

Thanks,
Manoj.

Please mark this as VERIFIED if it helps.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

I'm Glad that it worked.

Please mark my answer verified by selecting 'Yes' under Did this answer your question?

Was this reply helpful? Yes No
KarthikKota on at

Like (0)

Report

Awesome, worked thanks.

Was this reply helpful? Yes No