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
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.
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
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!
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
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"?
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional