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.
Check out the on demand sessions that are available now!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021