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
Super User III
Super User III

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
Super User III
Super User III

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

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
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (56,394)