Help building Flow to get response content from Microsoft Forms into a new OneNote page

[laurakaplan99]

Hello!  I am trying to build a Flow for the first time and am stuck building it out so that the full content from the Microsoft Form response transfers over into/creates a new page in my OneNote Notebook.  I tried using a template which only timestamps and indicates a response was received- doesn't actually include the content.  Tried searching for help and found a way to build a flow to create an HTML Table in OneNote which doesn't seem to make sense for my response data (it is a survey requesting a meeting for help on specific challenges-- pretty detailed responses on a 14-item Form survey). 

Your help is appreciated!

[edgonzales]

@laurakaplan99 

Hi there!  This is the weird thing about the Forms connector, but after you have the trigger that a response was submitted, you'll want to add an action "Get Response Details".  This will get the detail I think you are looking for.

It also might kick off an Apply to Each loop, but don't panic.  Just do your OneNote actions inside that loop and you should be fine.

Keep us posted.

-Ed-

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[laurakaplan99]

Thanks for the advice.  I'm getting close but not there yet.  Currently it is sending the content from the Form to OneNote but my latest issue is that it appears all jumbled together into one long paragraph (vs. separate lines for each response).  Any tips to separate out each question for separate, spaced out responses so they are easy to view by the committe who'll use the data?  Thank you again!

[edgonzales]

You bet.  When you're adding the stuff to OneNote, try adding spaces or returns in between each of the response fields (The dynamic values).  You can use whatever you'd like, but here's an example of one I did for events:

[laurakaplan99]

So here's what I have input for OneNote:

I hit "return" to space out each line of data/separate question, however here is how it shows up in OneNote:

[edgonzales · Accepted solution]

Ah, got it...ok.  So, OneNote formats the posts using HTML (check this article from Prarie Developer)  so you can use that to (hopefully) format your post from within Flow.

If you're not familiar with HTML, there are a bunch of online editors that you can use to build your document and it shows the code on the side.  Here's one I found.  I would just put some kind of weird character around the 'dynamic value' you want, and then replace the phrase and weird characters with the actual dynamic value when you drop it into Flow.

If you already know HTML, then you're off to the races!  But I don't, so that's how I would do it 

Keep us posted.

-Ed-

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[laurakaplan99]

This was super helpful and I am *almost* there with getting it how I want it.  The only remaining glitch is that if multiple answers are chosen for a question on Microsoft Forms, they are still being lumped together (delineated in brackets with quotation marks in between).  I'd love for them to be listed out (hit return in between each response item even if there are multiple selected responses per question) so they are more easily readable. Here's what it is creating now as an example:

[abm]

Hi @edgonzales  & @laurakaplan99 ,

I did tried to create some text in one note (Business) without the HTML tags and it did displayed with correct formatting (Spaces, carriage return etc.)

I did also tried with HTML tags but it displayed the text with HTML tags.

Let me know how it goes? 

Thanks

[v-bacao-msft · Accepted solution]

Hi @laurakaplan99 ,

For getting multiple checkbox values with expected format, please refer to the similar thread and see if it helps:

https://powerusers.microsoft.com/t5/Building-Flows/Saving-multiple-checkboxes-values-from-forms-to-e...

Please take a try.

Best Regards,

[laurakaplan99]

Hello!  I apologize I have been out of the office for a bit but am back to working on this project.  I still am stuck with my most recent issue around formatting (see my previous post and screenshots about brackets and quotation marks).  I tried combing through the suggested thread about replacing characters you cited but I'm afraid my skills (or lack thereof) are getting in the way of me understanding how to apply that to my flow.  I do not have an "input" chunk within my flow like the one that is referenced in the thread.  Any further help would be greatly appreciated.  

[abm]

Hi @laurakaplan99 ,

Here is what you need to do.

1. Add a flow action before "Create page in a section" (OneNote) called "Get response details" (Form). See the link which mentioned by @v-bacao-msft 

2. Once you added the flow action ("Get response details") then name the 'FormId' as 'MultiValueText' and map the 'Response Id' to 'Please endores your reason(s) for this MTSS request'.

3. Next we need to format the mutli selected values.

So in your example ["Consult for academic progress or learning issues", "Consult for addressing challenging behaviors"]

First we need to replace the the square brackets, double quotations and add a carriage return instead of the commas so that it will display line by line.

To do this add a new flow step "Compose" below "Get response details". click the Inputs text box then on your right handside you get Dynamics content and Expression tab menu.

Under the expression tab add the below replace functions which will remove [" character.

replace( , '["', '')

Once you added the function then insert your cursor after 'replace(' statement. See the link demo and add the form reponse object 'Reason for MTSS request'.

Try this and see whether it replaces the [" character.

Once you done then edit the flow and extend the replace function to replace ]" and comma to replace with carriage return character which I think '\n'.

Yes I know it is a bit complicated. That's the reason I mentioned to try only one replace expression and see the results. Then you can extend it one at a time.

If you need any more help let me know.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[laurakaplan99]

I greatly appreciate the people trying to offer detailed support but I think what I need is somebody to help me live/in real time.  I get stuck after the second step you describe of adding a new action to "get response details" inserted before creating a page in OneNote-- do you mean add a second "get response details" action (it populates automatically as "Get response details 2" since I already have the first one created (from the template).  Then, I get stuck on the next step as it won't give me options to "map to 'please endorse your reason...." for Response ID.  When I etner Form ID: MultiValueText it requires I choose from a drop-down menu or "enter custom value" so I selected "enter custom value."  Not sure if that is right or wrong.  Then the options for Response ID automatically reduce down to just one option of "List of response notifications Response ID."  Eesh. This is becoming more of a headache than it seems it should be.  Perhaps I should stop pursuing this Flow/automation project and go back to just manually copying over the survey responses into OneNote.  Again, all of your support is greatly appreciated but the process of getting help through detailed written-out multi-step directions is not very helpful in the realm of user support for "regular" folks like myself.  😞    Wish this software was more accessible to regular clientele.

[abm]

Hi @laurakaplan99 ,

You can skip the step 2 add add the compose action which I mentioned in step 3. Not sure how we can show this as live. You need skype or teamviewer software to share the screen. 

Thanks