cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
asaigner
New Member

Comment looping in Trello-Planner Migration

I create a flow to migrate data from Trello to Planner, but in the end I found a bug. When pasting the comments in the planner, it does correctly only on the first card, on the second card it copies the comments of the first and second cards, on the third card it copies the data of the first, second and third cards. I just don't know how to get out of this looping, does anyone have any ideas please?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

Hi @asaigner ,

 

Maybe you could consider adding a 'Set Variable' Action to set the array variable(dd) to null at the end of the current loop. When the next loop starts, the data in the array variable(dd) will be brand new.

vyujincuimsft_0-1655191708757.png

 

 

Best Regards,

Charlie Choi

View solution in original post

7 REPLIES 7
asaigner
New Member

migração.png

asaigner
New Member

flow:

 

1.PNG2.PNG3.PNG4.PNG

asaigner
New Member

card examples:parte 5.PNGparte 6.PNGparte 7.PNG

asaigner
New Member

the first task, with the correct formatting.
parte 8.PNG

 

the last one with broken formatting.

parte 9.PNG

asaigner
New Member

Expression used in the append to array variable next to Date:

formatDateTime(items('Apply_to_each')?['date'],'dd/MM/yyyy')

 

Expression used in the card description

join(variables('dd'),variables('space'))

.

fórmulas.PNG

v-yujincui-msft
Community Support
Community Support

Hi @asaigner ,

 

Maybe you could consider adding a 'Set Variable' Action to set the array variable(dd) to null at the end of the current loop. When the next loop starts, the data in the array variable(dd) will be brand new.

vyujincuimsft_0-1655191708757.png

 

 

Best Regards,

Charlie Choi

asaigner
New Member

thanks! you saved my flow! I'm very grateful!

 

doing what you instructed, ended up repeating the description of the card, so I just made this change and everything works perfect.

 

asaigner_0-1655213294190.png

 

thanks for the help again!

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

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.

Users online (1,709)