Power Platform Community Forum Thread Details

Hi all

I currently have an excel file which records all the responses from MS forms.

I would like to create a flow to collate and email the responses collected on each day, would this be possible? How can i extract that from the excel.

Many thanks in advance

Categories:

Using flows

@zacl

I believe in your excel you are recording the date of the collected response so what you need to do is to do as below:

1. Create a flow that is called on a Scheduled Recurrence Trigger

2. Then from excel connector call List Rows Present in a table with and Odata filter to get rows for today .. Please check below solution for a similar topic:

https://powerusers.microsoft.com/t5/Building-Flows/List-rows-present-in-a-Table-filter-Query-before-today-filter/m-p/752595#M103698

3. Then call the Action: Create HTML Table and pass the returned list of rows to it

4. Then you can use the output of Create HTML Table action in your email.

Hope this gives you an idea on how you can achieve this!