Hi,
So delegation issues as the one you are facing are difficult.
1) Is this SharePoint/DataVerse/What is your back end?
Unfortunately without the back end data information, its a toss up, what you can do.
But here are some questions
2) What is the Combobox1....Result when you convert it to Text and what is the .Value??? Is that some choice column? Is it multi?
I am going to make a suggestion because again you didn't share what back end is it.
A) Since its Text and you are using IN, is it really or can you use StartsWith?
B) I would change this so that you do this
Filter by date first,
Then filter by the other stuff
With(
{ JustDateRecords: Filter(XXXX, Column >= DateField && WhatEverColumn2 <= DateField },
Filter(JustDateRecords, add your text things here); // This assumes the Date Filter won't return more than 2000 records... will it? If not then you are fine
)
Share
Report
7
All responses (
Answers (
