Power Platform Community Forum Thread Details

I have a gallery that is being filtered by various text inputs and date pickers. in preview mode it works as intended, but once it's published it shows no data until you type in a search criteria and tab through all the inputs. even after resetting the inputs, you must type in what you're searching for and then hit tab through every text input and date picker before it will show the data. again, this issue does not exist in preview mode but only published version.

here is the code on the gallery

Filter(
    Aspect_CQ_Log,
    Or( StartsWith(
        BarcodeNumber,
        BarcodeSearchTxt.Value
    )),
    Or( StartsWith(
        Press,
        PressNumSearchTxt.Value
    )),
    Or( StartsWith(
        CQType,
        CQTypeSearchTxt.Value
    )),
    Or( StartsWith(
        OperatorName,
        OperatorNameSearchTxt.Value
    )),
   
    Or(
        IsBlank(CQSearchStartDat.SelectedDate),
        Date >= CQSearchStartDat.SelectedDate
    ),
    Or(
        IsBlank(CQSearchEnddat.SelectedDate),
        Date <= CQSearchEnddat.SelectedDate
    )
)

Categories:

Building Power Apps

I suspect you need And() in there somewhere with the dates - also set the Default of your search boxes to "" (empty string)

Filter(
    Aspect_CQ_Log,
    And(
      Or( 
         StartsWith(
            BarcodeNumber,
            BarcodeSearchTxt.Value
         ),
         StartsWith(
            Press,
            PressNumSearchTxt.Value
         ),
         StartsWith(
            CQType,
            CQTypeSearchTxt.Value
         ),
         StartsWith(
            OperatorName,
            OperatorNameSearchTxt.Value
         )
      ),
      Or(
         IsBlank(CQSearchStartDat.SelectedDate),
         Date >= CQSearchStartDat.SelectedDate
      ),
      Or(
         IsBlank(CQSearchEnddat.SelectedDate),
         Date <= CQSearchEnddat.SelectedDate
      )
   )
)

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee