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
Solved! Go to 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
Proud to be a Flownaut!
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
Proud to be a Flownaut!
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.
Awesome, glad this worked.
Yes SharePoint can be finicky when changing the Title Column.
Proud to be a Flownaut!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
90 | |
50 | |
36 | |
30 | |
27 |
User | Count |
---|---|
75 | |
60 | |
50 | |
43 | |
38 |