Filter Array to get only odd rows.

(0) Share

Report

Posted on by kyon84

Hi,

got Array of values, which I got from "Get Items" action. Now trying to filter my array by ID to get only rows odd ID.

I now there is "Filter Array" action but not sure how to configure in advanced mode...

Can I somehow use function ISEVEN? Or similiar?

Thank you.

Ales

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report

Use the mod expression.

Was this reply helpful? Yes No
chico 638 on at

Like (1)

Report

this is marked resolved by using "mod"
but is there an example on how that is being used?

Was this reply helpful? Yes No
kristof 67 on at

Like (0)

Report

Hi @chico I am also looking for a more performant way to get it work with one single action called: Filter Array but I suck at prompting Bing🤖 to get a working expression so I am seeking from 💡tips for humans or PA aliens 👽. See screenshot from my current flow which uses an apply to each to filter every second item.
What should go left branch?

Was this reply helpful? Yes No
kristof 67 on at

Like (1)

Report
Just noticed that I hook up my questions to a bit different query. Here is the solution you are looking for @chico

Even numbers are those numbers which are divisible by 2 and odd numbers which are not divisible by two.

So to get an array with IDs like 1,3,5,7... you want to divide the ID by 2 and make sure there is a reminder. That's what the mod function will provide. It returns the remainder after a number is divided by a divisor.

Mod( Number, Divisor )
Number - Required. Number to divide.
Divisor - Required. Number to divide by.
In advance mode of you filter query
@equals(mod(item()?['ID'], 2), 1)

or you can use the opposite:
@not(equals(mod(item()?['ID'], 2), 0))
In regular way:

Was this reply helpful? Yes No
chico 638 on at

Like (0)

Report

this is niiiiice

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@chico @UsernameIsTaken

You could even set up a Select action to perform something on every other, every 5th, … every nth item in an array without any ID number column…

How to perform something on every n items

Select Action

From: Range(0, length(PreviousOutput))

Map: If(equals(0, mod(item(),n)),

DoStuffHere,

PreviousOutput[item()])

Was this reply helpful? Yes No
kaijiayongshi 6 on at

Like (0)

Report

Can you go into more detail? Thank you~

Was this reply helpful? Yes No
kaijiayongshi 6 on at

Like (0)

Report

The red fonts 1 and 2 in the array are serial numbers. Here are 2 examples. I want to get the yellow information at the end of the serial number.

Was this reply helpful? Yes No