Powerautomating a flow to send email reminders - Apply to each failing

(0) Share

Report

Posted on by Akash23

Hi,

I was hoping i could get some support in running into an issue. I keep testing the flow and recieve this message:

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@variables('varDate7DaysOut')' is of type 'String'. The result must be a valid array.

I have no idea what to do. I have tried to search around.

Many thanks in advance

Screenshot (56).png

I have the same question (0)

All responses (7)

Answers (1)

Andrew_J 1,962 Moderator on at

Like (0)

Report

Re: Powerautomating a flow to send email reminders - Apply to each failing

@Akash23

This seems to me like a adddays function, you need to look at UTC and then adddays but use a -7, If that helps then great. But if you need anything more then I will look at later on today.

Regards

Andrew

Was this reply helpful? Yes No
Akash23 16 on at

Like (0)

Report

Re: Powerautomating a flow to send email reminders - Apply to each failing

Hi Andrew,

Thank you. I tried a couple of other methods and seem to be getting issues every time. I have attached the steps i have taken and can't seem to see where i am making the mistake.

Thanks,

Akash

Screenshot (57).png

Screenshot (58).png

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

Re: Powerautomating a flow to send email reminders - Apply to each failing

I am confused at the trigger for the flow and as I am on my mobile it is not easy to see the original image.

Was this reply helpful? Yes No
Akash23 16 on at

Like (0)

Report

Re: Powerautomating a flow to send email reminders - Apply to each failing

The triggers are so i can 7 days prior to project task due date send a reminder to the assigned person that there task is due for completion in 7 days.

I have set up the furst couple of lines to feed back the date and milestones that fall within the parameters. I have checked those actions and all tick off except when i try and automate the email part of the flow.

Does that make sense?

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (1)

Report

Re: Powerautomating a flow to send email reminders - Apply to each failing

@Akash23

I have been looking at this, whilst there is always many ways to doing things in flow, you may need need to look at this differently. The apply to each is looking for a variable so try something like the below which does the same. This is flow I created to pull a list of items every month and then issue the tasks to a group of people:

Let me know if the above helps, I am a learner myself so I can only apologise for not knowing it all.

Regards,

Andrew

Was this reply helpful? Yes No
Akash23 16 on at

Like (0)

Report

Re: Powerautomating a flow to send email reminders - Apply to each failing

Hi Andrew,

Thank you for all the support. I have managed to figure it out in a random way but it works.

When i apply to each to give me the 'value' and then apply to each again with 'Assigned to' as the output it seems to work and send everyone assigned to the task a email 7 days out.

I landed on it randomly and it works to what i require it to at the moment

Again, thank you so much for your help and support

Was this reply helpful? Yes No
Verified answer

Akash23 16 on at

Like (0)

Report

Re: Powerautomating a flow to send email reminders - Apply to each failing

Hi Andrew,

Thank you for all the support. I have managed to figure it out in a random way but it works.

When i apply to each to give me the 'value' and then apply to each again with 'Assigned to' as the output it seems to work and send everyone assigned to the task a email 7 days out.

I landed on it randomly and it works to what i require it to at the moment

Again, thank you so much for your help and support

Was this reply helpful? Yes No