cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
newpauser
New Member

Filter get item for Completed Tasks

Hi,

 

I am trying to create a flow so when a task is completed in Example Plan it updates the progress bar in the Sharepoint list. I have it 50% working so it will update the progress but it updates all the tasks in the list, I understand I need to filter it but having issues.

 

I have it in an earlier flow so when it creates both the Task & Sharepoint Item it creates the same title which is ID_Expenses_EmailAddress. I just need the filter to find it based on title but cant get there. Heres a screenshot of the filter part I have currently and the error message I get. Any advice appreciated.

 

Filter.jpg

 

 
body":{"status":400,"message":"The expression \"110_Expenses_user@company.com\" is not valid. Creating query failed

1 ACCEPTED SOLUTION

Accepted Solutions
Jcook
MVP

Hello @newpauser 

 

Filter syntax looks like this:

ColumnName eq 'value'

 

So in your example you should put:

Title eq '<Task>'

 

Replace <Task> with your Task dynamic content from planner


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

3 REPLIES 3
Jcook
MVP

Hello @newpauser 

 

Filter syntax looks like this:

ColumnName eq 'value'

 

So in your example you should put:

Title eq '<Task>'

 

Replace <Task> with your Task dynamic content from planner


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





this worked perfect thanks a lot. Had been looking at this for days. 

 

One problem I noticed is in the SharePoint list i changed the default column from Title to ExpenseID and Power Automate still assumed it was called Title. Once figured this out it works great.

 

 

@newpauser 

 

Awesome, glad this worked.

 

Yes SharePoint can be finicky when changing the Title Column. 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,761)