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,
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.)
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?
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.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 103 Super User 2026 Season 1
Haque 87
trice602 63 Super User 2026 Season 1