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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

SharePoint Get Items

(0) ShareShare
ReportReport
Posted on by 79

Hi,

 

How to filter sharepoint to get items from Title that contain this two categories

Say in the "Title" column if appear apple or orange get it's value name "Amount"

can help with the flow how the get items Filter query: should be?

Thanks

Zy_Sin_0-1716283473367.png

 

  • CU16071609-1 Profile Picture
    6,255 Moderator on at

    @Zy_Sin 

     

    Use the below syntax:

     

    Column_Name eq 'Value'

    Deenuji_0-1716283817643.png

     

    Documentation for the same

    Deenuji_1-1716283901462.png

     


    Thanks,
    Deenuji Loganathan 👩‍💻
    Automation Evangelist 🤖
    Follow me on LinkedIn 👥

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

  • Zy_Sin Profile Picture
    79 on at

    Hi @Deenuji 

     

    How do i get the value out? if column Title has Apple, i want to get the column it's Amount.

    do i set a config dictionary?

    Thanks

     

     



  • CU16071609-1 Profile Picture
    6,255 Moderator on at

    @Zy_Sin 

     

    To use or condition follow the below sytanx:

    (Title eq 'Admin') or (Title eq 'test1')


    Thanks,
    Deenuji Loganathan 👩‍💻
    Automation Evangelist 🤖
    Follow me on LinkedIn 👥

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

     

  • Verified answer
    CU16071609-1 Profile Picture
    6,255 Moderator on at

    @Zy_Sin 

     

    Use for each loop and iterate the get items response like below:

    Deenuji_0-1716285548620.png

     

     


    Thanks,
    Deenuji Loganathan 👩‍💻
    Automation Evangelist 🤖
    Follow me on LinkedIn 👥

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

  • Zy_Sin Profile Picture
    79 on at

    Thanks @Deenuji 
    great help

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 414

#2
11manish Profile Picture

11manish 335 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard