Unanswered

filter by empty cells in excel column

(0) Share

Report

Posted on by Apab

I have an excel file with column 'Deliver Date/Time'. The column gets filled via the power app by user. I want to create a gallery that only shows items not yet delivered. In other words a filter that returns rows where the 'Deliver Date/Time' is empty. Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

rswain 173 on at

Like (1)

Report
To filter the gallery based on whether the 'Deliver Date/Time' column is empty or not, you can use the following formula in the gallery's Items property: Filter('YourExcelTableNameHere', IsBlank('Deliver Date/Time')) Replace 'YourExcelTableNameHere' with the actual name of your Excel table and 'Deliver Date/Time' with the name of the column you want to filter on. The IsBlank() function will return true for any row where the 'Deliver Date/Time' column is empty, which will cause the Filter() function to include that row in the gallery.

Was this reply helpful? Yes No
Apab 7 on at

Like (0)

Report

Thanks so much, that worked perfectly.
If you could help with another issue please. So the input the user puts when delivery arrives is a date and time picker. But hen I see it populate in excel it's showing a difference of 11 hrs. From what I understand there is a conversion error even though I've set everything to local time zone. Is there a way to offset this, either in powerapps or excel?
Thanks

Was this reply helpful? Yes No
Apab 7 on at

Like (0)

Report

Also, with your solution, it only seems to work if 'Deliver Date/Time' column in excel is formatted to text or general. Any date and time format shows blank results in PowerApp.

Was this reply helpful? Yes No