web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create a planner task ...
Power Automate
Unanswered

Create a planner task from Excel

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I create a flow that works 1 time/ day.

The flow is listing all the rows from an excel file, it's making a filter with filter array because my excel files has 51000 rows.

After the filters is applied, i parse the result from the filter into a json format.

Then, i apply a switch to check if the value of "Status" eq "Active".

If the Status is active, i list all the task from a planner.

Before i create a new task, i check if the value of "DNS" is eq with the value of existing planner task name.

If the condition returns yes, i updated that planner task with new information based from that Excel.

If the condition returns no, i create a new task with the name of "DNS" value.

The flow work, or i think it works, because it makes the task in planner.

The issue is that the flow it's creating a new task for every row, is not checking if the name of the task already exists.

Can you help me to make this flow work?

 

ctodoran_0-1627368118235.png

ctodoran_1-1627368179259.png

ctodoran_2-1627368239020.png

ctodoran_3-1627368281749.png

ctodoran_4-1627368320191.png

ctodoran_5-1627368375037.png

ctodoran_6-1627368402340.png

ctodoran_7-1627368437094.png

 

 

ctodoran_0-1627368686696.png

 

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard