You’re offline. This is a read only version of the page.
Announcements
I have a flow set up so whenever a form is updated it fills out the information on a excel table. Every new entry is tagged with an ID that goes in numerical order. How do I retrieve the latest information from the "Grade column" to send that information on a email?
Hi @Anonymous ,
Use:
although i'm affraid that columns containing spaces will not work in Excel connector. You need to rename your column.
In the next steps, knowing that the answer contain only one row ( top=1), you can refer to values using:
body('List rows present in a table')['value'][0]['your_column'] (
where List rows present in a table is the name of the action which extracts the values from Excel and your column is the name of your column where the value you want to access is stored)
Hope it helps !
Share
Report
All responses (
Answers (
9,270
