Unanswered

Please help stuck in automate

(0) Share

Report

Posted on by Poweruser0509

I have created a MS form for survey and wanted to use power automate to transfer the response to sharepoint or onedrive including attachment/s. Ideally the response will divert to different folder depedning the answer on particular questions,e.g. if respondent answer he is from japan then the response data will be drop to japan folder and i will grant access to the japan manager only.

All responses (2)

Answers (0)

Poweruser0509 3 on at

Like (0)

Report

Re: Please help stuck in automate

Hi @Expiscornovus, thank you so much for all detail.
i have another questions, not sure if this can be automate or not? hope you can help!!

i created a MS form and customer from different countries will fill out.
1. i want the responses (e.g. age, gender etc) with attachment automate to 'LISTS'
For example: Peter from UK filled out MS form with his age, gender etc. and with an attachment, in LISTS
2. is it possible to add folder in list? because i want to restrict UK people seeing what other countires have submitted.
3. if point 1 is fesible, can me and my colleague get notify when get submission?

we are moitoring the submission from worldwide so is a bit complicated.
thank you again and hope you can help me resolve this!!
Expiscornovus 31,641 Most Valuable Professional on at

Like (1)

Report
Re: Please help stuck in automate

Hi @Poweruser0509,

You could collect the file content of the attachment and create a new file in the specific country folder.

Below is an example.

In this example I am retrieving the country from the user profile of the person responding. But you can also replace that Country by one of your questions. The approach would still be the same.

1. The Get File Content uses the following expression to retrieve the id of the attached file

Replace my question id r0d2c0ec03d734138a579ed7fdd378982 by your specific question id

json(outputs('Get_response_details')?['body/r0d2c0ec03d734138a579ed7fdd378982'])[0]['id']

2. The Create file uses the Country of the user profile and the name of the file attached. In the File name this expression was used

Replace my question id r0d2c0ec03d734138a579ed7fdd378982 by your specific question id

json(outputs('Get_response_details')?['body/r0d2c0ec03d734138a579ed7fdd378982'])[0]['name']

This could be the setup with a question instead of the Country field from the user profile