Share
Report
158Hello all, I have run into an issue with one of my flows. My current filter query does not work when a customer returns to a previous Planner bucket in MS Planner like this,
1. Customer goes from Planner Bucket A to planner Bucket B to Planner Bucket C filter works, new record/new bucket is added to list B
2. Customer goes from Planner Bucket A to planner Bucket B to Planner Bucket C then back to Planner Bucket A, new record is not added, the filter finds the old bucket not the most recent bucket
What I need is a way to capture the most recent Bucket from list B and use that in a variable in my filter, tried but no luck, I get an invalid query error below is my flow and filter. If body Length = 0 (True) then create the new record
(TaskChkListUID eq '@{triggerOutputs()?['body/TaskChkListUID']}') and (BucketID eq '@{triggerOutputs()?['body/BucketID']}') and (field_14 eq '@{triggerOutputs()?['body/field_14']}') and (field_16 eq '@{triggerOutputs()?['body/field_16']}')
I tried adding an additional get Items, filtering on UID then sorting DESC and Top Filter of 1 which returned the correct value (most recent Bucket) which I stored in a variable but I did this in a test flow and could not figure out how to insert this into my flow. Thanks for any help
All responses (
Answers (
