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.
