Answered

How to collect multiple email address on MS Form and Update SharePoint List via Power Automate?

(0) Share

Report

Posted on by berebel

I have an MS Form - which asks for an email address

I have a Flow running - which collects the email and resolves it to organizations' UPN and updates the item in SharePoint List

When it's a single email - it's fine the flow works with no problem - it captures the UPN and updates its row in the SharePoint list.

But let's say - I want to assign this task to multiple users: e.g. abc@xyz.com and def@xyz.com ... so I type both email address and separate them by a comma or semicolon - IT NEVER WORKS

Flow runs - but fails to update the SharePoint list with the item - it greys out - please see the screenshot below:

Is there any way to collect multiple email addresses within the same organization and get that updated in the SharePoint list via PowerAutomate?

Your help will be really appreciated... Thank you.

Categories:

Business Process Flows

All responses (3)

Answers (1)

berebel 45 on at

Like (0)

Report

Re: How to collect multiple email address on MS Form and Update SharePoint List via Power Automate?

@tom_riha
Yes - solution accepted... Thank you
berebel 45 on at

Like (0)

Report

Re: How to collect multiple email address on MS Form and Update SharePoint List via Power Automate?

Dear Tom @tom_riha ,

First of all - Thank you very much indeed for taking out time for me and advising a solution.

I tried to follow your solution - it works - but it needs two times array conversion
Verified answer

tom_riha 10,127 Most Valuable Professional on at

Like (1)

Report
Re: How to collect multiple email address on MS Form and Update SharePoint List via Power Automate?

Hello @berebel ,

you can process multiple entries, but you must turn them into an array, they can't be processed as a string.

1. use split(...) expression to split them by the separator, e.g.

split('email@email.com;email2@email.com', ';')

2. once you have an array you can use 'Select' action to put the email addresses in the correct format as expected by SharePoint and update it in the item

[ { "Claims": "user1@company.com" }, { "Claims": "user2@company.com" } ]

Community site session details

How to collect multiple email address on MS Form and Update SharePoint List via Power Automate?

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

How to collect multiple email address on MS Form and Update SharePoint List via Power Automate?

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates