Answered

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

(1) Share

Report

Posted on by strugglebus

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

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @strugglebus

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

Thanks

Was this reply helpful? Yes No
strugglebus 14 on at

Like (1)

Report

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"?

flow.pdf

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
strugglebus 14 on at

Like (1)

Report

@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!

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @strugglebus

Glad to hear that all working as expected.

Thanks

Was this reply helpful? Yes No
DW-18081230-0 16 on at

Like (0)

Report

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

Was this reply helpful? Yes No
strugglebus 14 on at

Like (0)

Report

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.

Was this reply helpful? Yes No