Get items in sheduled flow

(0) Share

Report

Posted on by Danny_Dicaprio

Hi Everyone

I need to Create a scheduled flow that runs weekly.

The flow should retrieve items from a SharePoint list and identify the dates in the "Next Action Date" column.

One week after the "Next Action Date," the flow should send an email to the requester listed in the SharePoint list.

Could anyone please help to fix the flow

I got stuck with adding condition to the flow

@items('Apply_to_each')?['Next_action_date'],addDays(utcNow(), 7))

the condition which Iam trying to check is if the next actiondate +7 = true I will send a email to the requestor corresponding to the email ID column from the Next action date

Categories:

General topics

I have the same question (0)

All responses (15)

Answers (2)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Danny_Dicaprio ，

If I understand correctly, do you want to send the email when Next action Date+7 is equal to today's date?

If so, please check this test:

addDays(items('Apply_to_each')?['Next_action_date'],7,'yyyy-MM-dd') utcNow('yyyy-MM-dd')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-yetonggu-msft

Thanks for the reply its showing an error where the expression in invalid

addDays(items('Apply_to_each')?['Next_action_date'],7,'yyyy-MM-dd')utcNow('yyyy-MM-dd')

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Danny_Dicaprio ,

Please look carefully at my flow screenshot.

What I gave you are two expressions.

You need to fill in the left and right sides of the condition respectively.

condition left:

addDays(items('Apply_to_each')?['Next_action_date'],7,'yyyy-MM-dd')

condition right:

utcNow('yyyy-MM-dd')

Use is equals to in the condition.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft

I am really sorry , still Iam facing an error

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'addDays' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'.

could u please help me to fix this error

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Danny_Dicaprio ,

Your ‘Next_action_date’ column has a null value, so flow will report an error that first parameter of addDays function is Null.

Please try to put this expression on the left side of condition, and the expression on the right side remains unchanged.

if(empty(items('Apply_to_each')?['Next_action_date']),null,addDays(items('Apply_to_each')?['Next_action_date'],7,'yyyy-MM-dd'))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like
a
(0)

Report
Copy link

Link copied!

HI @v-yetonggu-msft

Sorry for the delayed response '

The condition is working fine , but the flow is not working properly

I have set the next actions date as 2024-03-25 in my sharepoint list

the flow is as triggered for every minute

for the condition to match 2024-03-25 +7 = 2024-04-01

I have around 128 records in my SP list but the seems like number of iterations for apply to each is comming only upto 100

Do know how we can fix it ?

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Danny_Dicaprio ,

Is your requester column a people column?

I did another test for your reference.

This involves the limitation of condition.

I suggest you use Filter array to filter out 'Next_action_date+7' which is equal to today's date, then apply to each the item in Filter array and send emails to requesters who meet the conditions.

My SharePoint List:

My Flow:

if(empty(item()?['Next_action_date']),null,addDays(item()?['Next_action_date'],7,'yyyy-MM-dd')) utcNow('yyyy-MM-dd') items('Apply_to_each')?['Requestor/Email']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
srduval 1,796 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Go into the setting of the sharepoint get items and enable pagination. Set it to the maximum your license allows. enter 10000000000 and it will tell you what your limit is.

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft @srduval
Thanks'
I made all the changes Its working fine, one last issue Iam facing is if I want contents (other sharepoint column details like subject , ID ) inside the mail body for each record how do Ido it.

I tried the following way

But Iam getting this error "Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply_to_each_2' referenced by 'inputs' in action 'Send_an_email_(V2)' are not defined in the template.'.'."

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Danny_Dicaprio ,

Please check your expression in Send an email(V2).

Make sure you refer to Apply_to_each in your expression and not Apply_to_each_2.

-------------------------------------------------------------------------------------------------------------------------------

If I solve your problem, please mark my response as a solution so I can help more people who are experiencing this challenge in the future.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No