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

All responses (7)

Answers (1)

Sort by

abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @strugglebus

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

Thanks
strugglebus 14 on at

Like
a
(1)

Report
Copy link

Link copied!

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
Verified answer

abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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 14 on at

Like
a
(1)

Report
Copy link

Link copied!

@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!
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @strugglebus

Glad to hear that all working as expected.

Thanks
DW-18081230-0 16 on at

Like
a
(0)

Report
Copy link

Link copied!

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
strugglebus 14 on at

Like
a
(0)

Report
Copy link

Link copied!

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.