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:

Business Process Flows

All responses (3)

Answers (1)

Verified answer

v-litu-msft on at

Like (1)

Report

Re: compare total and filter

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.
peterhui50 5 on at

Like (0)

Report

Re: compare total and filter

still does't seem to work, not sure what I am doing wrong....
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: compare total and filter

@peterhui50

In expression use this-

int(string('56'))

Thanks

Hardesh