Forum Discussion
Microsoft Forms -Branching +Report Generation
MicrosoftHi NavinSri
Based on your needs, the following method may help you - you can set a required choice question asking the form taker to select their location, and the form owner can use the Responses View chart to see the distribution of responses by location for each question, form owner can also open the responses in Excel to further analyze the data as needs.
DingkunXie we need see each location wise responses for all the above questions
NavinSri the best way to do this is probably to build a flow in Power Automate to save each response to a SharePoint list (something we ALWAYS do at my company) and you can then analyse the responses by location in Power BI. Or you can use the flow to add each response directly into a dataset in Power BI.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- DingkunXieI am trying to understand your question. Can you tell me why the above method does not meet your needs?
