Hi Everyone,
I have a Tasks list in sharepoint online that has a column "Assigned To" with mutiple selection of people allowed, no groups.
I am trying to build a flow that will allow a reminder to be sent of all due tasks say 7 days before due date for each task in the list. However the mail needs to go to each user with only tasks assigned to them. The challenges I am facing is that, firstly I am not able to select email addresses directly, I have to loop through or first select "Assigned To" with internal field name being "AssignedTo0" and then the "Email ID", since the multiple people column generates array inside an array. I could share the Json schema if that would help.
I am able to generate and send an email for array index 0 ( inside the "Apply to each 3", filter array expression) since I have hard coded it inside an expression. I am not very well versed with power automate and expecially with arrays. If someone could point out how I could fix this issue to sequence through the all the array entries and send email to all users, would be highly appreciated.
Please find the flow that I have built currently. Please note, I am able to get the flow to work if its a single person selection in the "Assigned To" column, however the issue I am facing is when there are multiple people in the selection column.
I have looked thruough many community articles, however unable to find anything when it comes to multiple people in assigned to column.
Full Flow
01
