Getting list of all past Form responses, and re-apply the flow to them

(0) Share

Report

Posted on by KeringStoreSupp

Hello.

I have a flow that triggers everytime a response is submitted in Form.

It generates a document in my Sharepoint.

Now, I would like this flow to be run to all past responses on my form, so I will get all the PDF documents for the past responses I got from the user.

Is there a way to achieve this?

I tried with first() but obviously I get only the first one.

Maybe using an array containing all the responses?

Thanks for your help!

Andrea

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Brad_Groux 4,556 on at

Like (0)

Report

You aren't going to be accomplish this with a manually created trigger. You'll need to utilize the When a new response is submitted trigger, as it gives you access to the List of responses content. Your Flow could look like this: If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
KeringStoreSupp 19 on at

Like (0)

Report

Hello,
so I have to wait for a new trigger response to be submitted? Sorry, I don't get it very well.
I already have let's say 80 responses submitted.
What I would like to achieve is basically to run a flow associated to the form submission... for already submitted forms.
Now the flow runs for a new form submission, printing out the form.
Is there a trigger for a flow releated to the old ones?

Thanks,
regards

Andrea

Was this reply helpful? Yes No
v-zhos-msft on at

Like (0)

Report

Hi @KeringStoreSupp ,

I am afraid that there is no way to achieve your needs in Microsoft Flow currently.

There is no trigger or action to get the old response of the form in flow.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
KeringStoreSupp 19 on at

Like (0)

Report

Hello, as a workaround, I am using the related EXCEL file generated by MS Forms!
So I can map all the fields correctly, it's a very long activity but at least it's working.

What I am doing is reading each row in the related Excel file populated by the forms using "LIST ROWS PRESENT IN A TABLE", so that I can generate a PDF with all the already submitted data by form, using the fields in the Excel file.

Please be aware with the time/Date field. When reading from the Excel, it will translate in a number (floating).
There will be a floating type numer, with a dot ( "." )
So you will get something like: 43215.4569123 and not "05/24/2019 03.25 PM"

What I did is to separate the number in 2 numbers.
Then I am calculating 43215 days from 30th December 1899 ("Add to time")
So you will get the DAY.

The decimals are the fraction of a day.
so I am adding again "0." before the string splitted number, taking (for example): 0.4569123
and you have to multiply it with the seconds of a day.

example:
0.4569123 * 86400 ("Mul()" funcion in your flow)

Then I am adding this number to the start of day, that is midnight 00.00 ("Add to time")
Andy you will get the TIME.

What you have to do is then to join the two calculated times.
Hope this helps!

Andrea

Was this reply helpful? Yes No
v-zhos-msft on at

Like (0)

Report

Hi @KeringStoreSupp ,

You can use the concat() function to join the date and time together.

There is another simple method for your issue.

You can set the time/Date field format as Text.

Then the date will not change to number.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
keepinupwkaren 61 on at

Like (0)

Report

You can create a simple flow to capture your backlog by downloading your Form responses to excel and save the file. Create a manually triggered flow, don't add an input. Use list rows present in a table and other stages as needed and when you run, it will loop through all of the items that were previously submitted.

MicrosoftTeams-im...

Was this reply helpful? Yes No