Filter Blanks from a Gallery Linked to a Dataverse Table

(0) Share

Report

Posted on by GF-02121351-0

239

Hi,

I have a gallery that I would like to hide the row if the 'Mil Date of Travel' cell is empty. In the code I am trying to pull the data for the selected travel event and then do the filter.

Mileage Gallery.png

Search('Travel Reimbursements',
TravelSelection,
"cr0d7_travelid"),

Filter(
'Travel Reimbursements',
!IsBlank('Mil Date of Travel')),

Thanks

Categories:

General Questions

All responses (2)

Answers (1)

GF-02121351-0 239 on at

Like (0)

Report

Re: Filter Blanks from a Gallery Linked to a Dataverse Table

Thank you, that worked!
Verified answer

v-xiaochen-msft on at

Like (1)

Report
Re: Filter Blanks from a Gallery Linked to a Dataverse Table

Hi @gfeldhake ,

Please try this formula:

Search(Filter( 'Travel Reimbursements', !IsBlank('Mil Date of Travel')), TravelSelection, "cr0d7_travelid")

Best Regards,

Wearsky