@WGill There needs to be a separator. It can be anything... however, it would be best for the separator to be consistent with each submission. Otherwise it'll make for a more complex flow than it needs to be.
When the email addresses are returned, it'll be a string of emails separated by a separator (semi-colon, or comma.. whichever).
For example, the response output would look something like this. I don't know if users may enter a space between the separator (ideally you don't want this). You could account for it, however to simplify things, let's say the input looks like below.
Convert String to Array
You need to first convert the string of text to an array by using an expression.
The split() function takes two parameters:
split([string],[separator])
Add a Compose action and insert an expression. Use the split() function.
Click on the dynamic content tab and insert the appropriate dynamic content that is storing the string of email addresses. I've inserted the output from the Compose action in my demo.
Add a comma and insert the separator between single quotes. I'm using a semi-colon.
Run a test. The string of email addresses is now an array.
Format for Multi-Person Column
Add a Select action. In the From field, insert the output from the Compose action.
In the key field, enter Claims with a capital C. In the value field, insert an expression and use the item() function.
Run a test. Review the outputs.
Update Multi-Person Column
In the Create Item or Update Item action, locate the multi-person column field. Click on the icon to switch to input entire array.
Insert the Select action output.
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 are looking for a way to send multiple SharePoint List items that have been assigned to a user in an email—check out this YT Tutorial: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow
In this tutorial I cover:
✅ How to send multiple list items in a single email with a Power Automate Flow
✅ How to create a dynamic date range
✅ How to use the Convert Time Zone action
✅ How to use a Filter Query in the Get Items action
✅ How to count number of items in an array
✅ How to use the Select action to extract a users display name and email address
✅ How to create a unique list of email addresses
✅ How to use the Create HTML Table action
✅ How to customize the HTML Table with CSS styles
✅ How to use the Send an email (V2) action
✅ How to use the Append to String Variable action
✅ How to create a custom list of items for an email
✅ How to use the Send an email (V2) action
✅ How to display singular or plural text based on the number of items returned
