Answered

compare total and filter

(0) Share

Report

Posted on by peterhui50

I have a flow here

Everything works great and fast until it gets to the "filter array 2" . I just want to filter the Totals of less than 56 people before a table is created and email notification sent.

It looks like it is able to run fine, but it doesn't filter the Total to less than 56 at all. First it gave me a data type error - so I've added the int(56) to change it to integer but it still didn't work.

Any help would be great!

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@peterhui50

In expression use this-

int(string('56'))

Thanks

Hardesh

Was this reply helpful? Yes No
peterhui50 5 on at

Like (0)

Report
Copy link

Link copied!

still does't seem to work, not sure what I am doing wrong....

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @peterhui50,

It's caused the "Total" value get from the Excel table is a string type, we should use an expression to convert it into integer:

int(item()?['Totals'])

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No