cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
edgonzales
Most Valuable Professional
Most Valuable Professional

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.

View solution in original post

Hi @Anonymous ,

 

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-excel/m-p/259115#M26119

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.

View solution in original post

12 REPLIES 12
edgonzales
Most Valuable Professional
Most Valuable Professional

@Anonymous 

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.

Anonymous
Not applicable

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
Most Valuable Professional
Most Valuable Professional

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

 

Anonymous
Not applicable

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

edgonzales
Most Valuable Professional
Most Valuable Professional

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.

Anonymous
Not applicable

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
Most Valuable Professional
Most Valuable Professional

Hi @edgonzales  & @Anonymous ,

 

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

 

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi @Anonymous ,

 

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-excel/m-p/259115#M26119

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.
Anonymous
Not applicable

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
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous ,

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

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
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous ,

 

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

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements

Celebrating the May Super User of the Month: Laurens Martens

  @LaurensM  is an exceptional contributor to the Power Platform Community. Super Users like Laurens inspire others through their example, encouragement, and active participation. We are excited to celebrated Laurens as our Super User of the Month for May 2024.   Consistent Engagement:  He consistently engages with the community by answering forum questions, sharing insights, and providing solutions. Laurens dedication helps other users find answers and overcome challenges.   Community Expertise: As a Super User, Laurens plays a crucial role in maintaining a knowledge sharing environment. Always ensuring a positive experience for everyone.   Leadership: He shares valuable insights on community growth, engagement, and future trends. Their contributions help shape the Power Platform Community.   Congratulations, Laurens Martens, for your outstanding work! Keep inspiring others and making a difference in the community!   Keep up the fantastic work!        

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!    

Welcome to the Power Automate Community

You are now a part of a fast-growing vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun.   Now that you are a member, you can enjoy the following resources:   Welcome to the Community   News & Announcements: The is your place to get all the latest news around community events and announcements. This is where we share with the community what is going on and how to participate.  Be sure to subscribe to this board and not miss an announcement.   Get Help with Power Automate Forums: If you're looking for support with any part of Power Automate, our forums are the place to go. From General Power Automate forums to Using Connectors, Building Flows and Using Flows.  You will find thousands of technical professionals, and Super Users with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Power Automate community forums. Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered. Galleries: The galleries are full of content and can assist you with information on creating a flow in our Webinars and Video Gallery, and the ability to share the flows you have created in the Power Automate Cookbook.  Stay connected with the Community Connections & How-To Videos from the Microsoft Community Team. Check out the awesome content being shared there today.   Power Automate Community Blog: Over the years, more than 700 Power Automate Community Blog articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on the future of process automation. In the Power Automate Community Blog, you can read the latest Power Automate-related posts from our community blog authors around the world. Let us know if you'd like to become an author and contribute your own writing — everything Power Automate-related is welcome.   Community Support: Check out and learn more about Using the Community for tips & tricks. Let us know in the Community Feedback  board if you have any questions or comments about your community experience. Again, we are so excited to welcome you to the Microsoft Power Automate community family. Whether you are brand new to the world of process automation or you are a seasoned Power Automate veteran - our goal is to shape the community to be your 'go to' for support, networking, education, inspiration and encouragement as we enjoy this adventure together.     Power Automate Community Team

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Users online (2,948)