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.
Thanks in advance for the answer.
Hi, @Expiscornovus, thanks for previous answer
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.
Hi @dinerogs,
The Get Items action also has a query option, the Filter Query field.
You might be able to add something like the below in that Get Items action:
Share
Report
All responses (
Answers (
(Column eq 'x') or (Column eq 'y')
#1
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
