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

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

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

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





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

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

Highlighted
Super User III
Super User III

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.





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

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.

Highlighted
Frequent Visitor

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.

Highlighted
Super User III
Super User III

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.





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

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

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.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (7,875)