Extract record from Excel (Onedrive) table based on Microsoft Form response

[Ash_R]

Hi all,

The flow I'm trying to create should do the following:

1. User enters details in Microsoft forms
2. Details entered in the form are matched against a table in an existing Excel file that's stored on OneDrive
3. If the record is found, the entire row is selected (I used Get a Row)
4. Extract this entire row and put it in an email -> Getting stuck here

Example:

Data Stored in Excel file (in a table)

Name	Age	Gender
John	20	M
Jane	20	M
Jack	20	F
Jill	20	F

Microsoft form asks for Name, user enters 'Jill'

The output should be 

Jill

20

F

[abm]

Hi @Ash_R 

After the Get a row action you need the send email. You should be able to map the values from Get a row properties in your email action step. Where you struggling? If you need any more help please let me know.

Thanks

[v-bacao-msft · Accepted solution]

Hi @Ash_R ,

The first recommended method is to use the List rows present in a table action to filter the eligible rows, and then send the entire row through the HTML table. You can use the custom column to filter the columns that need to be displayed.

If you want to use the Get row action, you can use this configuration:

If you only want to display the columns you need, you can configure Value like this:

Best Regards,