Answered

Determine which column contains person details

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have an Infopath form which, depending on a $ value entered, shows the user different lists of approvers (which are populated by SharePoint groups). That is, as the value increases, a more senior list of approvers is displayed. Once the user selects an approver and submits the form, an Approval Flow is triggered.

I then need to determine which of the approver fields has been populated, and pass that email to the Flow's "Assigned To" field.

I've been researching expressions to see how this could be done, but have not yet found the solution, so would appreciate any suggestions.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Could you please share a screenshot of your flow's configuration?

Do you want to pass a value from Infopath form into your flow?

Further, do you want to trigger a approval flow when a Infopah form is submitted?

The Infopath connector is not supported in Microsoft Flow currently, I afraid that there is no way to achieve your needs in Microsoft Flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Kris

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply Kris.
My mention of Infopath was perhaps a red herring, as it's just a front-end to a SharePoint list. The Flow connects to the list, and I think I have found my own solution to the problem.

I have initialized a variable, and used the "Coalesce" function to determine which field has the approver email in it. This email is then passed to the Approval step. Needs more testing, but it appears to work.

Was this reply helpful? Yes No
GabrielStJohn Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello, @Anonymous!

Have you had a chance to apply @v-xida-msft‘s recommendation to adapt your Flow? Or maybe you've come upon a solution on your own? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel

Flow Community Manager

Was this reply helpful? Yes No