Filter a Gallery using calculated Sharepoint column

(0) Share

Report

Posted on by Steve-FTL

Hi,

I'm building my first canvas app form a SharePoint list...

I have a Gallery that consists of Check Type, Check, Lot Number, Filter Date.

FilterDate is a calculated SharePoint column =TEXT(Created,"YYMMDD") formatted as a number and returns 220510

I have a `PowerApps variable OnStart Set(varFilterDate, Value(Text(Now(),"yymmdd"))) that returns 220510.

Then I have set items property for the gallery to Filter('Patrol Inspection, FilterDate>=varFilterDate)

I get an error..... expected number date etc.

Not sure how to get this working.

Thanks for your help

Steve

Categories:

I have the same question (0)

All responses (2)

Answers (1)