Answered

GetItems ODATA compare two SharePoint list number columns

(0) Share

Report

Posted on by C_Crow

I have a materials catalogue and two of the columns are StockHeld and MinStock. These are both number columns in a SharePoint list. I'm trying to create a flow that will grab all items where the StockHeld is less than the MinStock.

On GetItems I am using the Filter Query of;

StockHeld lt MinStock

It returns an error of 'Fetching items failed. Possible invalid string in filter query.'

I've double checked the column names and that all rows have a number entered etc. Just cannot seem to jiggle the query about to work!

Any help is appreciated!

I have the same question (0)

All responses (7)

Answers (1)

Paulie78 8,418 Moderator on at

Like (0)

Report

Re: GetItems ODATA compare two SharePoint list number columns

Although what you want to do seems like a really simple objective if you have used a normal database system of any kind, but I do not believe it is possible to do what you want to do in the oData query.

Instead, you would have to return the list, and then pass it through a "Filter Array" action to reduce the rows down to the ones that have StockHeld less than minimum stock.

Do you know what I mean or would you like a demonstration?

Was this reply helpful? Yes No
C_Crow 19 on at

Like (0)

Report

Re: GetItems ODATA compare two SharePoint list number columns

Thank you for your response

I did attempt a filter array but I didn't get very far with it! A demonstration would be most appreciated

Thanks in advance

Was this reply helpful? Yes No
C_Crow 19 on at

Like (0)

Report

Re: GetItems ODATA compare two SharePoint list number columns

Probably also worth mentioning the goal was to have the results pull into a HTML table that will be emailed out to my team

Was this reply helpful? Yes No
Paulie78 8,418 Moderator on at

Like (0)

Report

Re: GetItems ODATA compare two SharePoint list number columns

Would you mind a video demo? It would just be quicker for me to produce.

Was this reply helpful? Yes No
C_Crow 19 on at

Like (0)

Report

Re: GetItems ODATA compare two SharePoint list number columns

Anything is appreciated, video is spot on 👍
Thank you

Was this reply helpful? Yes No
Verified answer

Paulie78 8,418 Moderator on at

Like (3)

Report

Re: GetItems ODATA compare two SharePoint list number columns

Here is how you can do it, I didn't edit the video or make it polished etc. But you should get the point. You could do a lot worse than subscribe to my YouTube channel while you are there! 😁 Let me know how you get on.

https://www.youtube.com/watch?v=qC2AgRuiZHc

Was this reply helpful? Yes No
C_Crow 19 on at

Like (0)

Report

Re: GetItems ODATA compare two SharePoint list number columns

Amazing, that was great thanks!
The Select addition was very helpful as I can think of a few flows I can use that function

Many thanks and I've subscribed to YT!

Was this reply helpful? Yes No