cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
peterhui50
Regular Visitor

compare total and filter

Hi

 

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!

Capture_image.JPG

1 ACCEPTED SOLUTION

Accepted Solutions

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'])Annotation 2020-07-29 105338.jpg

 

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.

View solution in original post

3 REPLIES 3
Hardesh15
Super User II
Super User II

@peterhui50 

 

In expression use this-

int(string('56'))
Annotation 2020-07-28 193726.jpg
 
Thanks
Hardesh

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

 

Capture_2.JPGCapture_1.JPG

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'])Annotation 2020-07-29 105338.jpg

 

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.

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,571)