Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Flow - MS Form to OneNote Page - Problem with duplicate responses

(1) ShareShare
ReportReport
Posted on by 14

I have cobbled together a flow that takes the responses from a MS Form and automates placing those responses into specific sections and pages of a OneNote notebook.  The flow appears to work as intended, except that instead of updating the page content with the response, it places 7 instances of the response into the page.  My OneNote notebook has 7 pages, so the quantity doesn't appear to be random, but I am stumped as to how to limit it to just the one response.

 

Any help is appreciated.

 

Thanks,

Brian

  • strugglebus Profile Picture
    14 on at
    Re: Flow - MS Form to OneNote Page - Problem with duplicate responses

    My use case might be a little too specific, but i will try to help if i can. This video helped a ton in getting the proper locations/links for my OneNote sections and Pages.

    https://www.youtube.com/watch?app=desktop&v=FbEJ-P5Zji8

    I used a Compose action to capture the Form inputs that i want to then use in an “Update page content” action. In my case, the Sections and Pages in the OneNote were already established, so i was just updating the content of the correct page with the Form responses. 

  • DW-18081230-0 Profile Picture
    16 on at
    Re: Flow - MS Form to OneNote Page - Problem with duplicate responses

    Hi Brian @strugglebus 

    I am trying to do something very similar to what you've described on this thread - is there any way you could share what it looks like as that might help me solve how to get mine to do the same?

    Thank you

    Darren Woodward

  • abm abm Profile Picture
    32,464 Most Valuable Professional on at
    Re: Flow - MS Form to OneNote Page - Problem with duplicate responses

    Hi @strugglebus 

     

    Glad to hear that all working as expected.

     

    Thanks

  • strugglebus Profile Picture
    14 on at
    Re: Flow - MS Form to OneNote Page - Problem with duplicate responses

    @abm 

    Thank you for that suggestion.  I had hoped an HTML table would be an easy option and provide some visual difference for when the form replies start being appended to the OneNote page.  However, your suggestion to pivot to a different solution is a good one.  I have done that and it works now!

  • Verified answer
    abm abm Profile Picture
    32,464 Most Valuable Professional on at
    Re: Flow - MS Form to OneNote Page - Problem with duplicate responses

    Hi @strugglebus 

     

    Thanks for the screenshot. I can see you are mapping the array output to OneNote. Can't you map each responses as one string by adding a compose and map the results under that. Finally map the compose output under the OneNote?

     

    Thanks

  • strugglebus Profile Picture
    14 on at
    Re: Flow - MS Form to OneNote Page - Problem with duplicate responses

    Hi, @abm 

    Thank you for your reply.  It is a rather long flow, so I combined several screenshots into a PDF and attached it.  The replication appears to be taking place in the "Create HTML table" step.  When I look at the outputs from a successful run, the HTML table has the seven instances of the response in it.  Is it because I've created an array in the "From"?

  • abm abm Profile Picture
    32,464 Most Valuable Professional on at
    Re: Flow - MS Form to OneNote Page - Problem with duplicate responses

    Hi @strugglebus 

     

    Could you post a screenshot of you flow and mappings please?

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow