cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
laurakaplan99
Level: Powered On

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

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!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

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

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 Smiley Happy

 

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.

Community Support Team
Community Support Team

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

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
12 REPLIES 12
Super User
Super User

Re: Hellp building Flow to get response content from Microsoft Forms into a new OneNote page

@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
Level: Powered On

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

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!

Super User
Super User

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

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:

20190705c.PNG

 

laurakaplan99
Level: Powered On

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

So here's what I have input for OneNote:

 

OneNote response field.PNG

 

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

 

OneNote screenshot.PNG

Super User
Super User

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

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 Smiley Happy

 

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
Level: Powered On

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

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:

sample mult responses.PNG

 

abm
Level 10

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

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

 

 

 

Community Support Team
Community Support Team

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

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
laurakaplan99
Level: Powered On

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

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
Level 10

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

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

Highlighted
laurakaplan99
Level: Powered On

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

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.  Smiley Sad    Wish this software was more accessible to regular clientele.

abm
Level 10

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

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

 

 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 74 members 4,253 guests
Please welcome our newest community members: