cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rnavrot
Helper I
Helper I

After I check Planner for duplicates, how to further filter out results?

I have a Flow that scrapes the IT Task List every 15min to poll for updates.

If it sees updates in the Plan, it will transfer them to an Excel Table.

Flow #2 then grabs that data from Excel and uses it to look up the corresponding Plan ID.

 

The cards ultimately move from IT to the sub-plan.

 

Flow #2 will go line by line down my Excel Table. Once we arrive at the sub-plan for any entry, we then look at the bucket it is going into for a card that already exists. If so, do nothing, validate that it has a different due date than the new card. If it DOES, create a new card with the new data. If that card already exists with that date, do nothing.

 

FINALLY, I need to cross-check the Buckets with the items on the list. This is where I need help.

 

Here is the logic in question.

rnavrot_0-1668125177150.png

 

 

After Flow has determined whether or not to create the card, it now needs to reverse check that there aren't items in the Sub-Plan that AREN'T in the Table. If there is a card in the sub-plan and not the table, we need to remove the Card from the sub-plan.

 

How can I check the tasks from my Bucket against my Excel Table?

 

Thank you.

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,793)