cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Muhammad07
Helper I
Helper I

Filter Array with Calculated Sharepoint

Hi Folks,

I am trying to filter my sharepoint list in power automate using calculated column. But Calculated column not working in OData query and neither in Filter array function. In filter array function it did not show up any data. If i use equal to operator it didn't matchup with any record.

PS i have 2 columns in sharepoint: Current Inventory, Preferred inventory and Pending Inventory. I want a filtered data where (([Current Inventory]+[Pending Inventory])*100)/[Preferred Inventory ]<70. So i created a calculated column 'Ratio' in share point which calculate this value and now trying to apply filter on that column in powerautomate.

How to resolve this issue. Any help would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @Muhammad07 ,

 

Please try:

@less(float(item()['Ratio']), 70)

vbofengmsft_0-1659062909773.png

 

I've made a test for your reference:

1\My SP List

vbofengmsft_1-1659062950292.png

vbofengmsft_2-1659062967450.png

 

2\Result

vbofengmsft_3-1659063069550.png

vbofengmsft_4-1659063081862.png

 

Best Regards,

Bof

 

 

 

 

 

View solution in original post

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @Muhammad07 ,

 

Please try:

@less(float(item()['Ratio']), 70)

vbofengmsft_0-1659062909773.png

 

I've made a test for your reference:

1\My SP List

vbofengmsft_1-1659062950292.png

vbofengmsft_2-1659062967450.png

 

2\Result

vbofengmsft_3-1659063069550.png

vbofengmsft_4-1659063081862.png

 

Best Regards,

Bof

 

 

 

 

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,645)