Power Platform Community Forum Thread Details

Hello I have been trying to take a MS Forms document and when the form is filled out, get the response details, and create a new Task in MS Project.

I have seen some posts on how to do this with MS Planner, but planner is to basic and I want tasks created in MS Project instead.

I have PA getting the response details but I get error saying the response is not in a JSON format. I am not entirely sure that this error message is correct but I did find this post. https://powerusers.microsoft.com/t5/General-Power-Automate/get-form-response-details-as-json/td-p/61065

I inserted a Select component to try and transform the data into JSON format.

It looks like it is setting the output okay, but when it connects to the MS Project Create new task, it throws a 302 error "The message is not in a JSON format."

I am wondering if the Root URL and Project ID are correct or maybe our company connection to MS Project is not setup correctly.

But then again, I have not been able to find anything for Forms to Project, it has all been Forms to Planner which seems odd that there isn't a connector into Project.

Categories:

Using flows

@Kbleck You might find this YT Tutorial helpful: How to Get a Microsoft Form RSVP Response into a SharePoint List

I cover the following in this video tutorial:

Although I cover how to get the MS Form data into a SP List, the same concepts should apply to your flow.

✅ How to get a Microsoft Form Response into SharePoint

✅ How to get a Microsoft Form ID

✅ How to get a Microsoft Form response

✅ How to Build a Microsoft Form with Conditional Fields

✅ How to used Branching in Microsoft Forms

✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

✅ How to parse a Microsoft Form multiple choice response as string of text

✅ How to convert a text response to a number

✅ How to use the Switch action

✅ How to create a custom email confirmation for a Microsoft Form submission

✅ How to Create a Custom View in a SharePoint list

✅ How to use the Compose Action

✅ How to write Power Automate Expressions

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok