Filter get item for Completed Tasks

[newpauser]

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.

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

 

[Jcook · Accepted solution]

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

[newpauser]

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.

[Jcook]

@newpauser 

Awesome, glad this worked.

Yes SharePoint can be finicky when changing the Title Column.