Unanswered

How to pass value from SPO column as a dynamic content into approval flow

(0) Share

Report

Posted on by vladisam1

Hi all,
I am new to Power Automate and struggling with feeding approver's email from Sharepoint Online list into "Assigned To" field of Approval flow. I am working on creating of Approval flow where creator of the record has to choose one value from the list (organized as list of emails in Approver column in SPO list). What am I missing?

Regards,

Vlad.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Pstork1 69,655 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Add a People/Group column to the document library. Call it something like Approver. Then have the user fill in that metadata when they save the document. You can then pick up the email address from that field in the flow.

Was this reply helpful? Yes No
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@vladisam1

I agree with @Pstork1 - his suggestion will work for you. If you want to limit who can be selected in the Person or Groups column, do the following:

Create a SharePoint group

Add the people who you can be approvers to the SharePoint group

When configuring the Person or Group column, in the "Choose From" dropdown, select the group you just created

Optional - in the column description, list the people in the group so users know who they can enter.

Was this reply helpful? Yes No
Jessie Chen on at

Like
a
(0)

Report
Copy link

Link copied!

@vladisam1 Hi Vlad, is there a separate SharePoint list? or when you say SharePoint list you mean the SharePoint document library. If it's a SharePoint document library , I think the previous answer would fit for you. Otherwise you would need choose the approver value from SharePoint list column.

Please mark my reply as a solution if you think it helps.
Thank you.

Best Regards,

Jessie Chen

Support Engineer
Asia Dynamics 365 Support
Customer Services and Support

Was this reply helpful? Yes No