You’re offline. This is a read only version of the page.
20
I want to add a condition to count the length of the output that I loop for the get item. Now I'm using 'apply to each' for the loop then get items from Sharepoint, then show. I already write the expression like this one length(outputs('Get_items')?['body/value'])
how should I write the condition after that? I would like to write a condition that counts the length of the item that I get from Sharepoint and has the column value equal to x or y . In Sharepoint, the data type of the column that contains the value x and y is choices.
I've added a condition in the Query Filter field of the Get List action. It is user-selected system name and date filters. But I want to count how many transactions in the system and the date I selected have the analyzing status, waiting for acceptance status, or completed. I want to count these data according to the conditions.
The dataset is below
| Date | System | Status |
| 2023/02/26 | Abc | Analysis |
| 2023/02/26 | Def | Complete |
| 2023/02/26 | Abc | Complete |
| 2023/02/25 | Abc | Analysis |
if user select 2023/02/26 and system name is Abc
the result should be like:
Analysis: 1
Complete: 1
It's a bit complicated. Or if you have another method, please suggest.
@v-jefferni Thank you very much, you’re awesome. I made a few modify, it worked pretty well.
Hi @dinerogs ,
With the help of Filter query, you can get the ouput of an array that includes selected Systems and Date from Get items action. After that, you can use Filter array actions in parallel branches and populate the results into a variable:
Best regards,
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
