Unanswered

From Forms to a multi-person column in SharePoint with Power Automate.

(1) Share

Report

Posted on by Heidi04

107

Hello,

I need help with a Power Automate flow. The flow involves two 'multi-select person columns' in SharePoint. I'm trying to transfer responses from a Microsoft Form to these columns in a SharePoint list, but I'm encountering issues. Despite several attempts, I keep receiving an error. I'm not an expert in Power Automate, so I would appreciate any guidance on how to correctly set up this flow.

Categories:

Licensing

Screenshot_25.11....

All responses (5)

Answers (0)

Heidi04 107 on at

Like (0)

Report

From Forms to a multi-person column in SharePoint with Power Automate.

Hello Deenuji_Loganathan,

I sincerely thank you in advance for your support!

Two workflows are needed. The first workflow should capture all responses from a Forms survey and enter them into SharePoint List A, then export them to an Excel file, and additionally send out an email notification. The Forms survey and SharePoint List A include multi-choice columns and person-type columns. The second workflow should be triggered as soon as the "Status" of an item in SharePoint List A is changed from "Pending" to "Approved". In this case, the relevant item should be copied exactly into SharePoint List B.
creativeopinion 9,897 on at

Like (0)

Report

From Forms to a multi-person column in SharePoint with Power Automate.

@Heidi04 It's hard to see where the issue is with the screenshot you've shared. Please click on each action to expand it and upload a screenshot of your flow with all actions expanded. Thx!
Heidi04 107 on at

Like (0)

Report

From Forms to a multi-person column in SharePoint with Power Automate.

Hello, Thank you for the great video, but unfortunately, it's not working for me.

I have a forms where responses are being transferred to a SP-List A. Additionally, in this SP-List A, there is a category named "Status", and as soon as the status is set to "Approved", the list item should be copied to another SP-List B (booth lists are identical). Unfortunately, the multiple choice columns that are correctly filled in SP-List A are not being carried over the SP-B. How should I correctly set up the workflow to address this issue? Thank you so much!
creativeopinion 9,897 on at

Like (0)

Report

From Forms to a multi-person column in SharePoint with Power Automate.

@Heidi04 You might find be interested in this YT Tutorial:

How to Get a Microsoft Form RSVP Response into a SharePoint List

In this Microsoft Power Automate tutorial, I’ll show you how to get your Microsoft Form responses into SharePoint. I’ll cover how to build a Microsoft form with conditional fields by using branching. You’ll learn how to format your multiple choice responses for a SharePoint multi-choice column as well as converting it to text. I’ll also show you how to take a text response and convert it to a number with a switch action and with an expression.

After adding the response to SharePoint, we’ll send the user an email confirmation with all the details of their form submission.

At the end of the video I’ll show you a few tips and tricks on working with a SharePoint list.

IN THIS VIDEO:
✓ 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!
Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram
Deenuji_Loganathan_ 5,903 on at

Like (0)

Report

From Forms to a multi-person column in SharePoint with Power Automate.

Hi Heid04,

Please share the error details, so that we can suggest based on the error details.

Thanks,

Deenu