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
)
&&
Date( >=StartDate.SelectedDate && Date <=EndDate.SelectedDate
)))
Thanks Warren, the date name was just in a test environment, will be re-naming to something more suitable, cheers
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