Unanswered

Power Automate - Storing CSV files submitted in MS Form response

(0) Share

Report

Posted on by stevewesson

Hi Team!

I am currently building a workflow which starts with an MS Form and the form contains a question where the responder has to submit a csv file. I need to be able to store that csv file after it has been submitted but also update and master csv with data from the cv that has been submitted.

I have tried to on Power Automate but am having some difficulties - could any assist or steer me in the right direction?

Thanks,

Steve

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (0)

stevewesson 28 on at

Like (0)

Report

@Sundeep_Malik - You were so helpful before could you assist?

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @stevewesson

Not much idea about this. Nor I have used forms with csv files.

But I can suggest you some things.

Make use of file content if available.

If not save it to a place where you want to save it to. After that give some delay. Then after that start a child flow. Child Flow will access the content of the file. Then just take the values from that csv file and update it in your list.

You can also try it without child flow too, just give a delay so that the file is uploaded where you intend it to.

Then use appropriate action to get the file content of the file.

File content is the key here.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (1)

Report

@stevewesson @Sundeep_Malik

If you just need it uploaded to some SharePoint Group site, then you can make that group the owner of the form & it will automatically create any uploaded files in a Site > Documents > Apps > Forms > Question Name > All uploaded files

If you then need to send that somewhere else, that will require parsing some of the Form response to get the file name that you can then use in a Get file content by path.

As for parsing the CSV to then add lines to a master CSV…

If your CSV has double quotes “ around any item with in-data commas, then you can start with this CSV to dataset template:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191

Was this reply helpful? Yes No
stevewesson 28 on at

Like (0)

Report

Thank you for your advice takalota, I will try this now and get back to you with any queries.

Was this reply helpful? Yes No
stevewesson 28 on at

Like (0)

Report

Hi @takolota - I am the owner of the MS form where submitters have a question where they can attach the file and I need to make the owner a site in Microsoft Teams. I understand SharePoint sits behind MS Teams but as I am not the Owner of the Teams site where I need the file copied so how do I go about making the site the owner of the form. I have attached the settings I have on the MS form but cant see how I make the Teams site an Owner of this form.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (1)

Report

@stevewesson

Sorry, I forgot to mention that setting is a little weird to find.

If you go out to the Forms menu that lists all the forms you can edit, then you can click on the 3 dots on the form card to pull up a menu. That menu should have a “Move” option & if you click that it will display a list of Teams you can move it to.

Was this reply helpful? Yes No
stevewesson 28 on at

Like (0)

Report

Hi takolota. I have made myself the owner of the Teams channel in question and moved the relevant form to this page however I cant seem to find the form responses in the Teams Channel. I have the option to connect my forms account but when I click to configure, it does not give me the option of the receive notifications when a response is updated.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@stevewesson

I'm not sure I've ever seen that menu before. As for notifications, I would usually use the Outlook Send email action to send myself or anyone else notifications whenever someone submits a form.

Now as for finding the MS Form uploads, if the SharePoint/Teams site now owns the form, any file submissions should go to a folder in the site's document library by default.
So if you click on Documents on the SP site, then you should see this folder called "Apps". Then when you click into that, there should be a folder called "Microsoft Forms" & inside that a folder with your form's title as it's name & inside that a folder for each file upload question in that form that contains all the file uploads for that question.

If you just need them stored on this site, then that is all you should need to do. If you also need to do other actions with the file whenever one is submitted, then there are some extra steps you will need to add to the flow to Parse JSON to get the file's name & get the file content by it's path using the path of the default folder & the file-name you just parsed.

Was this reply helpful? Yes No
stevewesson 28 on at

Like (0)

Report

Thank you so much for your help this has all helped so much in setting up my flow. So I have got the files into the relevant SharePoint Area and also the answers to the form requests are now updating into a CSV table. The last thing I am struggling with to complete the flow is parsing the content of the uploaded file in the MS form that is copied into the SharePoint File into an excel file. I need the content of that new file and any new file submitted parsed into a CSV file held on SharePoint but as I haven't done that before I am struggling for a solution. I have attached my flow for better understanding.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@stevewesson

“

As for parsing the CSV to then add lines to a master CSV…

If your CSV has double quotes “ around any item with in-data commas, then you can start with this CSV to dataset template:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191”

If this doesn’t work for you, you can try a Office Script CSV parsing template or try to get a 3rd party connector for it like Encodian.

Was this reply helpful? Yes No