Create bucket and task in planner from an excel file

(0) Share

Report

Posted on by gennarodp

294

Hello i have an excel file with a table structured as following

ITEMS. TASK

A. PLAN

A. DO

A. CHECK

B. DO

C. CHECK

i want to create a instant flow that create in planner different buckets for each items and below task as in table.

anyone can help me ?

thank you

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

gennarodp 294 on at

Like (0)

Report

any one can help me ?

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (1)

Report
Hi @gennarodp,

What's the mean of ITEMS. column? It is task name or bucket name?

I assume that this is a bucket name. You could following these steps to approach that:

length(body('Filter_array'))
body('Filter_array')[0]['Id']

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
gennarodp 294 on at

Like (0)

Report

I will try.

thank you @v-litu-msft very much

Was this reply helpful? Yes No
gennarodp 294 on at

Like (0)

Report

hello @v-litu-msft ,
i have tried the flow but it repeats the creation of the same bucket for each activity.
It is not the result that i would like to had.

I would like to have a single bucket and below each activity assigned.

Can you help me ?

Thank you

Was this reply helpful? Yes No
gennarodp 294 on at

Like (0)

Report

hello @v-litu-msft , news please ?

Thank you

Was this reply helpful? Yes No
AChan2 8 on at

Like (0)

Report

Thanks for the info. I have followed the instructions but it seems the yes condition missed the Bucket id; so I have an extra question about the Bucket id for the yes condition. Attached I received the error with the current flow and logic. It seems to me it's about the Bucket id. I entered the Bucket id as
if(not(empty(body('Filter_array'))), body('Filter_array')[0]['Id'], null) for yes condition. For no condition, I put down
if(empty(body('Filter_array')), 'DefaultBucketID', body('Filter_array')[0]['Id'])
Any suggestion to get it running? Thanks.

Was this reply helpful? Yes No