cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (39,437)