Convert comma seperated emails into multiple people

(1) Share

Report

Posted on by Pathfinder

Hi there,

I have a PowerAutomate flow, that updates the content of 'People' column in a SharePoint list (with the 'allow multiple selections' option enabled) based on another column in the same list (email adresses), the flow works great if the email columns include only one email, however, if the columns has one the one emails (comma separated), then the flow will return user not found error, I think it's because the flow thinks that (user1@domain.com; user2@domain.com) is one email rather than multiple.

Is it possible to configure the flow to recognise multiple email addresses individually and update the 'People' column to add multiple people?

Thanks in advance

Screenshot 2024-07-01 at 11.17.29 AM.png

Categories:

Business Process Flows

All responses (1)

Answers (0)

lbendlin 7,794 Super User 2025 Season 1 on at

Like (0)

Report

Re: Convert comma seperated emails into multiple people

Change your assumption. Instead of expecting a single email, always expect a list. Use the text splitter to create an array, and then iterate over that array. If you only have a single email then the array will have only one row, but the process will work all the same.