cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ctodoran
Regular Visitor

Create a planner task from Excel

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

 

 

 

0 REPLIES 0

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,196)