Answered

Building a reminder with some difficulties (library, calculated columns)

(0) Share

Report

Posted on by Kuchen

The following flow is supposed to check every day the library if there is any contract with an approaching due date. I used "Filter array" because I am not able to use ODATA with the calculated column that throws the contract date.

I appear to be stuck since I can't find the issue, even though the flow appears to run fine.

Any ideas?

Categories:

Building flows

All responses (7)

Answers (1)

Sort by

Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Kuchen

Is your question about the filter array not finding any records?

Make sure the date formats are the exact same when comparing
Kuchen 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, my problem is that no records are found even though atleast one with the matching date (tomorrow) exists.
I do have a different date format in SharePoint (dd.MM.yyy) but if I change it to "adddays(utcnow(),1,‘dd.MM.yyyy’)" it throws an error: "the expression is invalid.".
Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Kuchen

Try formatting the date coming from SharePoint to match the format of the adddays expression.
Kuchen 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Sadly that isn't an option since there are other resources that rely on this information in this specific format.
Kuchen 30 on at

Like
a
(0)

Report
Copy link

Link copied!

To get the correct format I changed it to Concat(addDays(utcNow(),1,'dd.MM.yyyy')) , but it still doesn't send the e-mail.
Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Kuchen

I am able to get the original expression to work.

addDays(utcNow(),1,'dd.MM.yyyy')

I believe I found the issue, You have 2 loops. The second loop that has the SharePoint value, needs to be removed.

You should be referencing the values from the filter array inside the email. Not the SharePoint action.
Verified answer

v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kuchen ,

Please take a try with screenshot below:

The first value in the Condition(Modify the expression with your own column expression):

formatDatetime(item()?['Modified'],'yyyy-MM-dd')

The second value in the Condition:

formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd')

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.