Forum Discussion

josephljh's avatar
josephljh
Copper Contributor
Mar 16, 2023

Display Individual results to participants

I am trying to collect survey responses using Microsoft Forms and display the individual's results immediately upon completion. I was thinking of adding some form of visualisation (radar chart) to display their result. Would this be possible? 

microsoft forms
Survey

5 Replies

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Mar 17, 2023

    josephljh you can't generate your own visualisations unless you build a flow in Power Automate to send the form response to Power BI or Excel.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

    • josephljh's avatar
      josephljh
      Copper Contributor
      Mar 17, 2023

      RobElliott Thank you for your reply. Would it be possible to extract a specific participant's response from the form to Power BI or Excel? Instead of extracting responses from all participants that completed the survey. 

      I am trying to extract a response from each participant who completed the form in Excel, and then generate his/her/their visualisations onto Power BI. This would be unique to the individual. 

       

      Thank you!

      • RobElliott's avatar
        RobElliott
        Silver Contributor
        Mar 17, 2023

        josephljh well you can always manually copy each response from the excel spreadsheet in the Responses screen into Power BI.

         

        Rob
        Los Gallardos
        Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)