Unanswered

How can I length the output with condition?

(0) Share

Report

Posted on by dinerogs

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.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
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:

(Column eq 'x') or (Column eq 'y')

Was this reply helpful? Yes No
dinerogs 20 on at

Like (0)

Report

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.

Was this reply helpful? Yes No