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 |
Solved! Go to 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,
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video Tutorials
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,
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
85 | |
60 | |
51 | |
43 | |
38 |
User | Count |
---|---|
89 | |
81 | |
74 | |
62 | |
44 |