Jun 06 2023 08:35 AM - edited Jun 06 2023 11:46 PM
I am trying to create a survey across 4 different locations, however when I receive the response, I would like to see all the responses at single place with respective those 4 locations, is there any way we can do that?
I have tried branching option, but I am not getting accurate result in single page.
Jun 06 2023 11:29 AM
@NavinSri I'm not quite sure I understand the question, but are you asking the user for their location as one of the questions?
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Jun 06 2023 11:55 PM
Jun 07 2023 01:04 AM
Hi @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.
Jun 08 2023 12:27 AM
@Dingkun Xie we need see each location wise responses for all the above questions
Jun 08 2023 02:05 AM
Jun 08 2023 02:30 AM
@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