Put Variables in Apply to each loop

Like (0) Share

Report

Posted on 18 Aug 2021 03:49:20 by Prajnya

Hi Team I am facing a issue below, please help me to resolve this

Step 1: I have initialized a variable diffdates as integer, which I want to find the difference of day (today, task end date)

Below in the Apply to each loop, I am trying to find out the values using some formula in Set Variable

Like I have added Task Name and its corresponding Project Name in the Email body I want the DateDiff of the corresponding tasks to be displayed.

Below I have attached the email

Please help me in this. Thank you in advance.

All responses (6)

Answers (1)

v-bofeng-msft on 18 Aug 2021 at 08:42:27

Like (0)

Report

Re: Put Variables in Apply to each loop

Hi @Prajnya :

This is due to the nested structure of your flow: the body of the email is actually completed in ”apply to each3“, because ”apply to each3“ is a sub-loop of ”apply to each 2“, so the datediff obtained in the body of the email is always current A fixed value of ”apply to each 2“ loops.

My suggestion is to reorganize the structure of this flow.

Best Regards,

Bof
Prajnya 45 on 18 Aug 2021 at 08:19:04

Like (0)

Report

Re: Put Variables in Apply to each loop

Hi @v-bofeng-msft

When I run the flow
Attached here the Email

The Date diff it is taking as 84 for all tasks. not forming array for this.
Prajnya 45 on 18 Aug 2021 at 08:05:40

Like (0)

Report

Re: Put Variables in Apply to each loop

Hi @v-bofeng-msft
I just wrongly presses Accept as solution, please be with me I am sending the instances I have tried, Thanks
Verified answer

v-bofeng-msft on 18 Aug 2021 at 07:57:42

Like (0)

Report

Re: Put Variables in Apply to each loop

Hi @Prajnya :

I noticed that you have obtained the correct value and saved it in a variable. Why can't you call this variable directly?

Could you please tell me what is the meaning of "But not able to form an array in the EmailBody"?Do you you want to group these dates into an array?If so,you could try "append to an array" action.

Best Regards,

Bof
Prajnya 45 on 18 Aug 2021 at 07:00:31

Like (0)

Report

Re: Put Variables in Apply to each loop

Hi @v-bofeng-msft

Thank you for your quick response
Yes, I am getting correct Date Difference Value in this Step,

But not able to form an array in the EmailBody
Please find my below images, I am getting correct Day Difference using the same formula you have mentioned above but I want them to be displayed in the Email also like Task name, Project Name of the Task

If insert the variable vardiffdates in the email body then it is taking 84 as the date difference of 1st task not making array, also Append to String Variable but not worked.

Please help in another way, Thanks
v-bofeng-msft on 18 Aug 2021 at 06:23:24

Like (0)

Report
Re: Put Variables in Apply to each loop

Hi @Prajnya :

Sorry,I'm not sure what your current problem is.Could you please tell me :

Did you get the correct datediff value at this step?

About how to get the number of days between two Dates

div(sub(ticks(startOfDay(utcNow())),ticks(startOfDay('2019-05-04T08:00:00Z'))),864000000000)

If you have obtained the correct datediff value, then just insert the variable vardiffdates in the email body.

Best Regards,

Bof