cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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?

 
 
 
 
 

image.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @Kuchen ,

 

Please take a try with screenshot below:

1.png

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.

 

View solution in original post

7 REPLIES 7
Highlighted
Super User III
Super User III

Hello @Kuchen 

 

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

 

Make sure the date formats are the exact same when comparing





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Highlighted
Frequent Visitor

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

Highlighted

@Kuchen 

 

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





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Highlighted
Frequent Visitor

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

Highlighted
Frequent Visitor

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.

Highlighted

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.





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Highlighted
Community Support
Community Support

Hi @Kuchen ,

 

Please take a try with screenshot below:

1.png

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.

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (12,584)