Unanswered

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:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report
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" } ]

Was this reply helpful? Yes No
berebel 45 on at

Like (0)

Report

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

Was this reply helpful? Yes No
berebel 45 on at

Like (0)

Report

@tom_riha
Yes - solution accepted... Thank you

Was this reply helpful? Yes No