cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
awoodyyc
Regular Visitor

Apply to each created when pulling "To" email address from SharePoint list

I'm attempting an automated Approval workflow based on a PowerApp.

 

I have two SharePoint Lists

 

Employee Vendor Requests - requests are added via a PowerApp

Approvers - List of approvers with columns for Country, Name, Role (Financial Approver or Data Steward) and Email

 

When I select the UserNameEmail column an Apply to each field is automatically created. That doesn't seem like it should be a problem, but the Send email from shared mailbox choice never runs when I check Flow history and I'm not sure why.

 

7-23-2020 4-50-19 PM.png7-23-2020 4-50-27 PM.png7-23-2020 4-50-33 PM.png

 

The apply to each value is 'body('Get_Finance_Approvers')?['value']

 

The UserNameEmail value is items('Apply_to_each')?['UserNameEmail']

 

This is kicking my butt, any help would be greatly appreciated.

1 REPLY 1
JohnAageAnderse
Super User
Super User

Hello @awoodyyc 

The action "Get_Finance_Approvers" says it all. You are getting a collection of approvers, so using any dynamic information from it will create an "Apply to each" 👌

 

Use a variable to collect the email addresses from "UserNameEmail" and use the variable in the To field.

Kind regards, John

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (64,576)