You’re offline. This is a read only version of the page.
28
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?
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.
Share
Report
All responses (
Answers (
