compare total and filter

Like (0) Share

Report

Posted on 28 Jul 2020 12:37:31 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 29 Jul 2020 at 06:23:57

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 28 Jul 2020 at 19:17:34

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 28 Jul 2020 at 14:22:00

Like (0)

Report

Re: compare total and filter

@peterhui50

In expression use this-

int(string('56'))

Thanks

Hardesh