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 Automate
Unanswered

Filter Query

(0) ShareShare
ReportReport
Posted on by 2

New to the forum, requesting help as i am struck

I am trying to create a flow to update existing items based on the current status. e.g. i have 4 rows created with Name "Customer1" with status as "Pending" and when i create 5th Row for "Customer1" with Status as "Completed" all the existing 4 rows should get the status updated to "Completed" from "Pending".

I need formula for Filter Query under Get items control. currently updated formula "triggerOutputs()?['body/Title']" which isnt working.

 

any help in getting a formula will be a great help. thanks in advance.

BharathiN_0-1689888027043.png

 

Categories:
I have the same question (0)
  • wskinnermctc Profile Picture
    6,519 Moderator on at

    You need to type in the column name that you are trying to filter in the SharePoint list Close Pre Items based on trigger.

     

    Let's say I was trying to filter a Get Items by a column in the list named "EmployeeNames" with the output of a trigger that is When an Item is created.

     

    The Filter Query would be:

    EmployeeNames eq 'triggerOutputs()?['body/Title']'

     

    Get Items Filter QueryGet Items Filter Query

     

    Let me know if this helps,

     

  • BharathiN Profile Picture
    2 on at

    Thanks that helps.

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 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard