
Announcements
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?