Unanswered

Add column to Excel to compare against MS Planner

(0) Share

Report

Posted on by RBMadsen

Hi
I've come to realize that my skills are not sufficient at this point to finish the flow I've started building, so I am hoping someone here can help me to the finish line.

I have an export from Navision in csv format with Sales orders. This csv file is imported to MS Planner with Automote. This I got to work. My issue now is, that the csv file is updated and overwritten every 15 minutes and my current flow adds the whole list to Planner again, causing x amount of duplicates for each run. I've been told that the solution is to "add a column to the Excel table for if the row has been added to planner yet. Then when the row is added to Planner have the flow also update the Excel row/column to say 'Yes' & thus mark it as already added. Then when the flow run it can filter your Excel to only the rows that do not have 'Yes' in that column." Quote from user @takolota

I really hope someone has enough patience with me to get this up and running.

Thanks in advance

BR Ronni

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@RBMadsen If you are using an automated trigger for your flow—would you consider using a Recurrence Trigger instead?

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok
For more flow troubleshooting tips—check out This YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
In this tutorial I cover:
✅ How to troubleshoot a false Condition action result
✅ How to get dynamic content when it isn’t selectable from the list of dynamic content
✅ How to troubleshoot an Apply to Each action that isn’t looping through
✅ How to troubleshoot a skipped Apply to Each action
✅ How to troubleshoot a Filter Query
✅ How to use a SharePoint yes/no column in a Filter Query
✅ How to use Compose actions to troubleshoot a Power Automate flow
✅ How to troubleshoot multiple emails being sent
✅ How to troubleshoot multiple Teams messages being sent

Was this reply helpful? Yes No
RBMadsen 8 on at

Like (0)

Report

Hi @creativeopinion
This is how it looks right now:
The two actions are 1: apply to each and 2: Condition

Was this reply helpful? Yes No