Forum Discussion

NavinSri's avatar
NavinSri
Copper Contributor
Jun 06, 2023

Microsoft Forms -Branching +Report Generation

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...
microsoft forms
RobElliott's avatar
RobElliott
Silver Contributor
Jun 06, 2023

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)

NavinSri's avatar
NavinSri
Copper Contributor
Jun 07, 2023
For example, I am trying to collect information from US, Europe and Asia. I would like to collect the information through Survey (using MS Forms). There are no unique questions for all the locations, the questions are similar across all the locations, however while collecting the responses for a particular question I want to see how percentage (responses) varies across different locations on the same page. In other words, I want to see the data (as displayed in graphs) for all locations at the same time.
  • DingkunXie's avatar
    DingkunXie
    Icon for Microsoft rankMicrosoft
    Jun 07, 2023

    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.

    • NavinSri's avatar
      NavinSri
      Copper Contributor
      Jun 08, 2023

      DingkunXie  we need see each location wise responses for all the above questions 

      • RobElliott's avatar
        RobElliott
        Silver Contributor
        Jun 08, 2023

        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

Resources