cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MIA27
Helper III
Helper III

How to obtain data of expired or to be expired in 15 days - data in schedule export

I want to export the data which is either less than today date or date+15

Color format also to be applied like if less than today red font and today or greater than today then blue else black

 

Below method I used in PowerApp in an color event to obtain the result - this I posted, just to make clear my requirement

With( { wRemind: DateAdd( Today( 15, Days ) }, If( ThisItem.RenewalDate <= Today(), Red, ThisItem.RenewalDate <= wRemind, Blue, Black ) )

 

 

Please guide for the below :

A.

How to filter in ODATA query for the above situation

 

B

I will use HTLM table to obtain the data from GetITems

Then please advise how to compose to get the colors as discussed above,

 

 

 

 

4 REPLIES 4
David-
Solution Sage
Solution Sage

I can help you with the ODATA query part, but I don't know how to accomplish your second part. You would format the query in your Get action like :

David_3-1659276076957.png

  • The first expression is: formatDateTime(utcNow(),'yyyy-MM-dd')
  • The second expression is: addDays(utcNow(),15,'yyyy-MM-dd')

Of course, if you meant you want to get everything that has expired and will expire in the next 15 days inclusive, then you would just use the second expressions and format your query as wRemind le '[second expression]'

 

Thank you for your reply.

still unable to find a solution.

 

By your above solution, the data is getting filtered, which further I will be using HTML table to process further.

But within that table how to change the the color of the renewal date accordingly is the question.

 

Please advise if any idea further.

 

@MIA27 as I mentioned in my initial response, I don't know how you would handle the formatting aspect of your problem.

Any one can give me more idea how to further compose my html table, so that my requirement can be obtained,

waiting since few days with no answer.

At least Possible or not possible?.

I guess it should be possible as it is getting possible in power App coding which is posted in first post.

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,581)