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
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
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
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492