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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,925)