I am looking for a condition to create records based on Expiry date column=10 days and similar views. I used Next 10 days condition but the data isnt right:
I suggest you make a calculated field (days to expiry) that compares (datediff) between today and the expiry date. Create a view that shows only those records where the date to expiry = 10.
I should mention that if you have users in different time zones, you may get different (unexpected) results. You will need to convert your dates to local before doing the calculation. If everyone is in the same time zone, you can get away with it.
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
I want to segregate active and expired records through views. I have my expired views set. Active view has all my data. This is the condition I am trying which is ending up in no records.
Hi @Teresa24486 ,
I think the issue here is that your view will show only the records due in exactly 30 days.
Perhaps changing the calculated field from text to decimal and changing the filter on the view to DueDate > 15 and DueDate =< 30 will give you the results you are looking for.
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Check out the new Power Platform Community Connections gallery!