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?

I have the same question (0)

All responses (7)

Answers (1)

Jcook 7,779 Most Valuable Professional on at

Like (0)

Report

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

Hello @Kuchen

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

Make sure the date formats are the exact same when comparing

Was this reply helpful? Yes No
Kuchen 30 on at

Like (0)

Report

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

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.".

Was this reply helpful? Yes No
Jcook 7,779 Most Valuable Professional on at

Like (0)

Report

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

@Kuchen

Try formatting the date coming from SharePoint to match the format of the adddays expression.

Was this reply helpful? Yes No
Kuchen 30 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Kuchen 30 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Jcook 7,779 Most Valuable Professional on at

Like (0)

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

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.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

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

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.

Was this reply helpful? Yes No