Notifications
Announcements
I will select the date and system. Then want to filter the data out that "How many records does a date before the user's selected date contain data whose status is not complete?" How should I write the expression? I need data to come out as integer.
Hi @dinerogs,
It should be possible to combine both filter queries into one action by combining the two with an and function. After that you don't have to use a union and simple the length of the outputs of that one Filter Array action.
Hi, @Expiscornovus,
I use the Sharepoint for the database. Now, after I get the data, I use the first array filter for querying datasets whose task open date is earlier than the user's selected date. Then use the second array filter for queries whose status is not complete. Then count the length of the data by union, but it’s not work. I want to know how many records have a previous open date and a status not equal to completed?
Can you share a bit more details about your setup, for example a screenshot?
My main question would be, what data source are you using? (Dataverse table, SharePoint list, Excel file, etc.)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 245 Super User 2025 Season 2
Expiscornovus 207 Most Valuable Professional
trice602 190 Super User 2025 Season 2