Using Flow with an Excel List to create multiple tasks

[Sw1zero]

Hello

I need help.

I'd like to create multiple tasks from an excel sheet. I use "create task from Excel Row". It's not a problem. But additionally it should put all the tasks I'd like to create in a bucket which information is in the same row like the task itself. If the Bucket doesn't exist it should create this bucket first.

The excel looks like this:

Phase	Due Time	Bucket	User
Task 1	01.01.2021	242	John Hamilton
Task 2	12.12.2021	242	Markus Aurel

So I need, that these tasks are in the same bucket.

If I would first use "Create new Bucket" and then "Create new task" it alwasy create two buckets in Planner with the same name "eg. 242".

I'm not a native english speaker so I hope you understand my problem 🙂

Cheers

[tom_riha]

Hello @Sw1zero ,

you could check if a bucket with the name already exists before you create one. List buckets, filter the result by the bucket name ('Filter Array' action), and if the filtered array is empty (there's no bucket with that name, 'Condition' if the array length == 0), create it. Then you can add the new task either in the new bucket or in the existing one returned by the 'Filter Array' action.

 

[Sw1zero]

thanks @tom_riha 

if the bucket number doesn't exist, it means it should create a bucket under the condition no, am I right? 

how do I put f(x) in Condition?

thanks!

[tom_riha · Accepted solution]

Hello @Sw1zero ,

in the example above it should create the bucket under the condition Yes: if the array length is 0 = no bucket was found. But you can define your own condition, just make sure that you create the bucket only if the array is empty.

Expressions are added via dynamic content -> expressions

[Sw1zero]

Hi @tom_riha 

Now it works! Thanks a lot!

for my understanding between these functions:

- Difference between 'Name' and 'Name (formatted)'?

- what does array length = 0 means? 0 = the same name or 0 = differences in sign?

- why do I need to filter array?

[tom_riha]

I'm glad you made it work, for your questions:

- Difference between 'Name' and 'Name (formatted)'? | I don't know, you can try to store them in a 'Compose' action in the flow and you'll see what values they have.

- what does array length = 0 means? 0 = the same name or 0 = differences in sign? | length(array) = 0 means that the filtered array after the 'Filter Array' action doesn't contain any bucket, length of the array is 0 (if it found 1 bucket it would be 1, 2 buckets would be 2...). 

- why do I need to filter array? | The 'Filter Array' is used to search only a specific bucket among all the buckets. 'List buckets' will return an array with ALL buckets in your Planner, and you must filter only the one, specific bucket where you want to create the task. That's what 'Filter Array' does, it'll take list of all buckets, filter it, and return only the bucket(s) that fit the condition.