Updating an existing task in planner with a filter on

(1) Share

Report

Posted on by Medes

Hello all,

My current flow (from excel to planer) uses a lot of filters a parallel branche in order to:

Create a new task (if the title of a task doesn't match a name in excel)

Update an existing task (if the title of a task does match a name in excel)

Delete a task (if the title of a task doesn't exist in excel)

I'm experiencing problems with the second last. Using a condition, if false will create a new task and if true will update and existing one. I truly don't know how to fix my situation. 😅

Here are screenshots of my flow:

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Medes

You didn't explain the problem, just that you have one as in i see the title, and you say you have an issue, but can you explain it clearly what its doing that you think is wrong, and what you expect it to do, and a sample of the data, as well as run, where it did something, just not what you wanted.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Medes 72 on at

Like (0)

Report

Oops sorry about that, I'm over-tired from trying to fix this and forgot to explain lol.

I'm not sure how to explain the problem other than it doesn't work. As explained above, I'm trying to filter out:
1. Patients that are already added to the planner
2. Patient "names" that contain only "0"

This, for a fact works.

Then, after the filters, I'm trying to Update the tasks in planner with the remaining names/id's.

My problem is that i cannot figure out how to do that. What do I put for the task ID in "Update task details" so that the only patients remaining can have their tasks updated.

I have no clue, what to fix or what is causing issues.
Do I have to add a third branch and a third condition just for what I want to happen? Or can I keep it with the "Create a new task for a new patient" condition?
Is the condition output wrong?
Is the task ID wrong?

The screenshots I added in my first post are of my current flow and set up. When I run it, an error message pops up saying:

Thanks

Was this reply helpful? Yes No