Filter gallery by dropdown and date range

(0) Share

Report

Posted on by Matt383

405

Hi,

I have a gallery that iam trying to filter by a few drop downs, as well as by date range. The dropdown works fine, just having some troubles getting the date range to filter. Any advice would be much appreciated

Filter(EngineTimeSheet,
(Len(JNdrop.Selected.Value)= 0 ||
JobNumber = JNdrop.Selected.Value
) &&
(
Len(TYPEdrop.Selected.Value)=0 ||
TypeOfWork = TYPEdrop.Selected.Value
)&&
(
Len(USERdrop.Selected.Value)=0 ||
Name = USERdrop.Selected.Value

)

Spoiler (Highlight to read)

Date( >=StartDate.SelectedDate && Date <=EndDate.SelectedDate

&&Date( >=StartDate.SelectedDate && Date <=EndDate.SelectedDate

)))

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 151,883 Most Valuable Professional on at

Like (1)

Report
Re: Filter gallery by dropdown and date range

Hi @Matt383 ,

Apart from Date being a very bad name for a field and you had a bracket in the wrong place in the bottom code, this is correct structure assuming your values are valid

Filter( EngineTimeSheet, ( Len(JNdrop.Selected.Value)= 0 || JobNumber = JNdrop.Selected.Value ) && ( Len(TYPEdrop.Selected.Value) = 0 || TypeOfWork = TYPEdrop.Selected.Value )&& ( Len(USERdrop.Selected.Value) = 0 || Name = USERdrop.Selected.Value ) && Date >= StartDate.SelectedDate && Date <= EndDate.SelectedDate )

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Matt383 405 on at

Like (0)

Report

Re: Filter gallery by dropdown and date range

Thanks Warren, the date name was just in a test environment, will be re-naming to something more suitable, cheers

Was this reply helpful? Yes No