Showing results for 
Search instead for 
Did you mean: 
New Member

Get Email Adress Dynamically from Sharepoint List from Form

I have a flow set up to pull responses into a Word Doc template, convert to PDF and then push the attachment out via email.  All of this flow is working flawlessly but I'm stuck on the last step of the flow:



I have a SharePoint list with Location Names and the manager of those locations.  The response form has the Location Names and I'd like to use that response to map and pull the specific email address to add to the To: line of the email.  My thought was to use the Get Items action and filter with ODATA but how exactly do I map that to another column in the SharePoint list?


I honestly thought this would be the easiest part of the flow but I can't seem to figure it out.  Any help is greatly appreciated!

New Member

I think I've figured out the first part of the issue:


When pulling the dynamic content from the form, it adds a line break at the end of it so the Filter Query isn't able to look up based on that value.  I've tried adjusting the filter to startswith rather than eq, still no luck. 


Any ideas where to go from here? 

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,435)