I like to mark records in gallery base on last modified date in color. But the formula "If(DateDiff(ThisItem.ModifiedDate, Today()) <= 3,Color.Green)" is not working. The value of "ThisItem.ModifiedDate" is not get.
Hi @ArtU ,
Is this SharePoint you are using, if so
If( DateDiff( ThisItem.Modified, Today() ) <= 3, Green )
You will get a Delegation warning on this however. Also where are you putting this code?
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
I put it at Gallery.Fill
I update it as "If(DateDiff(Now(), Today()) <= 3,Color.Green)", it works. so it's "ThisItem.ModifiedDate" value get issue. this value is from sharepoint list last modified date.
i made a Sort and Filter at the Items property for the gallery. It likes this.
HeaderGallery.Selected.Value = "YES",
SearchBox.Text in ID
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.