Power Platform Community Forum Thread Details

Complete newbie here, so please be gentle.

I am trying to create the following flow: Submit MS Form --> Get Response Details --> Add Row Into Table --> Send Email

There is a VLookUp in the Excel table, turning one row of the submitted form data (store name) into an email address (store email address). All works perfectly up until this point.

Sending the email fails as the field is supposedly empty.

Where have I gone wrong and how can I fix it, so the full flow runs successfully?

Categories:

Building flows

Excel does not work as a middle calculator for a flow. If you get the flow to work the way you have it set up, I doubt it will be consistent.

https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/#known-issues-and-limitations-with-actions

Whatever vlookup is doing in the Excel workbook, you will need to do with the flow instead. So if the vlookup that is in Table1 is using the column Store Location to lookup the Store Email in Table2, you need to get that completed within the flow.

So currently your steps I see are:

Update a row in Table1
Send and Email
- Use data from the Update a row in Table1

You will need to add steps so it will look more like:

Update a row in Table1
Get a Row from Table2
- This will use the Store Location to filter or lookup the exact row in Table2
Send an Email
- Use data from Update a row in Table1
- Use the email from Get a Row in Table2

So basically you replace the Vlookup with a Get a Row step.