web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to get items if a ...
Power Automate
Unanswered

How to get items if a quantity in column A is less than column B from SharePoint list?

(0) ShareShare
ReportReport
Posted on by 15
Hi everyone.
 
I want to check (once a week) if the quantity in column A is less than column B from the same SharePoint list.
 
For example:
Column A is the number of products in stock.  (QTY = 30)
Column B is the safety stock.  (QTY = 5)
 
If the column A is less than 5, it will be gotten to the list.
Then, it will be sent by email to be ordered.
 
Now, I can't get items from the SharePoint list.
If anyone knows, please suggest me.
 
Many thanks.
 
Categories:
I have the same question (0)
  • Srini007 Profile Picture
    3,323 Super User 2025 Season 2 on at
     
    It's better if you keep your flow screenshot in detail and let us know where you facing the issue. This will better understand you issue and suggest some solutions to resolve
     
    If I have answered your question, please mark it as the Answered. If you like my response, please give it a Like.
     
    Regards,
    Srini
     
     
  • Verified answer
    Chriddle Profile Picture
    8,416 Super User 2025 Season 2 on at
    Filter all list items:
     
    coalesce(item()?['TestNo'], 0) is less than coalesce(item()?['TestNo2'], 0)
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 463 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 427 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard