Populate different excel spreadsheets based on form input

(1) Share

Report

Posted on by hyp

Hi all,

Noob here and I am hoping for someone can be kind and help me out.

I have a MS form with one of the questions being a dropdown list of project names.

Will I be able to use Power Automate to populate different spreadsheets with the form inputs based on the project name selected?

For example, if the respondent chooses Project C in the form dropdown list, then all the inputs collected in the form will go to the existing spreadsheet for project C. If the respondent chooses Project A, then all the inputs will go into Project A's existing spreadsheet.

Can this be done with Power BI?

All responses (1)

Answers (1)

Verified answer

v-alzhan-msft on at

Like (0)

Report

Re: Populate different excel spreadsheets based on form input

Hi @hyp ,

You could achieve the requirement within Microsoft flow.

You could get the response details from the form, and add a switch case for each of the option project, you could create the insert row action for each project on each case.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.