Hi, I have a SharePoint list named 'Systems' it has a Titlle field and a field called 'SustemMaintainer'. 'SystemMaintaiiner is a 'Person Or Group' columns that allows multiple selections and people only.
In my flow I got the correct row by calling getItems and filtering based on the title column. so I have an array with one row, and that row has an a column that contains an array of people columns:
[ { "Claims": "i:0#.f|membership|russell.gove@xx.com", "DisplayName": "Gove, Russell", "Email": "Russell.xx@xx.com", "Picture": "https://xx.sharepoint.com/sites/GLMasterData/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Russell.Gove@tronox.com", "Department": "Infrastructure Services", "JobTitle": "Sr SharePoint Architect" }, { "Claims": "i:0#.f|membership|xx.xx@xx.com", "DisplayName": "xx, xx", "Email": "John.xx@xx.com", "Picture": "https://xx.sharepoint.com/sites/GLMasterData/_layouts/15/UserPhoto.aspx?Size=L&AccountName=John.Njoroge@tronox.com", "Department": "CFO Staff", "JobTitle": "Manager Accounting Analysis" } ]
How do I go about sending an email to the Email addresses in that array.
The expression
body('getItems')?['Value']?[0]?['SystemMaintainer']]
gets me the list of objects, But how do i extract the email addresses from thos objects in a format thats sutable for sending an email?
Hi,
If anyone is still active on this thread, I followed the above instructions but there is an error when it gets to the 'select email address' action - it says "The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array'. My column type is a person or group, allowing selection of person only. Note: I have tried the expression starting with 'first' as well as the one below.
@faustocapellanj could this solution of getting emails as an output be used to set item level permissions for a SharePoint list item using that specific flow control? Forgot the actual name of it, just know it is there.
I.e. run a flow that (1) stops inheriting permissions on an item (2) gets the user emails from a [permission field] (just standard user/group field with multiple values) and then (3) use those emails to set the EDIT permissions for the item
Cheers and thanks, this was a good thread to read up on.
Instead of leaving the Key blank, press this button and enter the formula there with no key.
The result will look like the below.
From there use the Join action from Data Operations. Use the output of your select as the "From" and the semi-colon to join them.
If you are still having trouble please consider opening a new thread and tagging me if you need more help.
Thanks,
Carl
Sorry to bring up an old thread. I really cannot figure out how to do this.
I need to get the email addresss from a sharepoint person or group column that allow multiple selection.
I need the emails because I need to perform an action "Grant access to an item or a folder" and the recipient must be email addresses.
I followed what is mentioned in 2019. However the "Select" action is changed. I tried it myself and I can get a Json respond like:
[
{
"": "email1@abc.com"
},
{
"": "email2@abc.com"
}
]
How can I convert above format into email1@abc.com;email2@abc.com;?
This works for me but with one issue. Its only grabbing the first two emails from my sharepoint column?
How can I make it grab all of them? A loop wont work for my use case. I am writing to an excel row which I'm using to add members to a group via powershell.
Hi @faustocapellanj good day
when "select" named "get mail" step, shows error as below after run, but the output from "get items" is not Null.
"The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array."
any ideas, thanks so much
Resolved!
items('Apply_to_each')?['actionWith0']
item()?['Email']"}]
Still not getting this work work. Getting this error for the 'Select' operation
ankit_singhal
7
Super User 2025 Season 1
Michael E. Gernaey
4
Super User 2025 Season 1
David_MA
2
Super User 2025 Season 1