Power Platform Community Forum Thread Details

I have an MS Form that has a Power Automate flow running on submission.

The flow contains 2 levels of approval,

1st is line manager which is working fine, it gets the line manager form the users O365 profile.

2nd approval is from a manager specified within the MS Form, is a drop down text field which would give the output "Joe Bloggs" for example

Im looking to take this output and convert it to the users email address e.g. jbloggs@company.com so that the approval can be sent.

Ive tried to use a multi line IF statement within a Compose component as in this example i found https://community.powerplatform.com/forums/thread/details/?threadid=54e8f5d8-bae4-4d5f-8657-a4352b8ea67d

But when i try to use the compose Output in the approval form "assigned to" field it fails to pick up the output address and the flow fails at that point with this error:

"the request failed. error code: 'graphlookuprequestfailederror'. error message: 'user lookup request to graph failed lookup for user identifier: <then lists the entire IF statement>"

Ive also tried dropping to a single line if(equals(triggerBody()?['FIELD FROM FORM']?['Value'],'Joe Bloggs'), 'jbloggs@company.com', '') but get an error it still fails

If anyone can help i would be hugely grateful to get rid of this headache :-)

Categories:

General topics