cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Knhmayo
Helper I
Helper I

Export Planner Task with multiple assignments to Excel

Hello--I'm trying to export tasks from multiple planners into a single excel file.  I'd like for there is be a single column in the excel sheet that lists the names of the users to whom the task is assigned.  Can't figure out how to get there...  Any help?  Thanks! 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yiwenxie-msft
Microsoft
Microsoft

Hi @Knhmayo 

 

It seems like your flow is with no major configuration problem, you just need to add a step ‘Set variable’ to null in the end of ‘Apply to each’.

 

I’ve made a test and have run it successfully.

The result of my flow is:

3.10-5.PNG

 

The following steps are for your reference:

3.10-2.PNG

 

The detailed step for ‘Append to string variable’:

3.10-3.PNG

After the dynamic content ‘Display name’, just input an ‘enter’ from the keyboard.

This ‘enter’ is used to beautify the display of ‘Assigned to’.

 

The detailed steps for ‘update a row’ and ‘set variable’:

3.10-4.PNG

The expressions used:

trim(variables('Assigned to'))

null

 

For more info about the functions used:

trim()variables().

 

If you still have the problem, please feel free to let me know.

 

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

 

View solution in original post

2 REPLIES 2
Knhmayo
Helper I
Helper I

I think I figured that I need to create a variable and append a string, but the way I have done it, I'm getting lots of duplicative entries (such as listing my name multiple times in the cell).  It looks like it is adding the assignments for every new task to the list from the previous task... so my list of assignments gets longer, and longer, and LONGER.  Clearly I need it to reset between each iteration.... any help??

Knhmayo_0-1615335028769.png

Knhmayo_1-1615335076891.png

 

 

 

v-yiwenxie-msft
Microsoft
Microsoft

Hi @Knhmayo 

 

It seems like your flow is with no major configuration problem, you just need to add a step ‘Set variable’ to null in the end of ‘Apply to each’.

 

I’ve made a test and have run it successfully.

The result of my flow is:

3.10-5.PNG

 

The following steps are for your reference:

3.10-2.PNG

 

The detailed step for ‘Append to string variable’:

3.10-3.PNG

After the dynamic content ‘Display name’, just input an ‘enter’ from the keyboard.

This ‘enter’ is used to beautify the display of ‘Assigned to’.

 

The detailed steps for ‘update a row’ and ‘set variable’:

3.10-4.PNG

The expressions used:

trim(variables('Assigned to'))

null

 

For more info about the functions used:

trim()variables().

 

If you still have the problem, please feel free to let me know.

 

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

 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,710)