there is new column "MonthYear" which is calculated from column "Check-In DateTime". The issue is PowerApps doesn't filter column "MonthYear". Here is formula in MonthYear column: Text([Check-In DateTime],"mmyyyy")
Example: Check-In DateTime = 09/01/2019 07:00 AM, MonthYear is calculated=092019
Formula in PowerApps:
ClearCollect(Database, Filter(tbl_CheckPoint_Data, MonthYear = "092019"))
Hi @ratanapouy ,
Can you share more details with the error information? Which is the output format of MonthYear column? How many items does the data source have? Is there any delegation warning?
I have made a test on my side, and don’t have any error with filtering. In my test, tankdetail is a SP list with calculated text column “t”, then I put formula on button’s Onselect property , and It works fine.
Please make sure that your MonthYear Column and "092019" are all the same type, only the same type value can evaluate in your formula Maybe more information can be helpful to sort out this issues.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications