Power Platform Community Forum Thread Details

Send Email Flow from a Filtered Sharepoint List

Hello,

I'm trying to set up a flow where I can send reminders for people that are in charge of an action that has not been done yet. It's a 3 day out of due date reminder. I use get itens to filter the sharepoint list to the values that I need. And so far this is working good.

The problem starts in the "Send E-mail" step. I need to send an e-mail for every e-mail in "Responsável" field for each of the actions that will be soon overdue.

The problem is that I'm entering in an automatticaly "Apply to each" box that always shows this error message: "The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body']' is of type 'Object'. The result must be a valid array."

Relevant Information: The responsible field is set for "Person or Group" and can have more than one person as responsible. When I add only "Responsável" than there is no error, the problem is that it returns information like this: [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|XXXXXXXXX","DisplayName":"XXXXXX","Email":XXXXXX","Picture":"XXXXX","Department":"XXXX","JobTitle":"XXXXXX"}] which can't be used in the field "Send to".

I need to get the values "Responsável" DisplayName and "Responsável" Email without entering this apply to each.

Captura de tela 2023-01-11 170249.jpg