cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Problem with duplicate rows Using Flow to export SharePoint List to Excel One Drive for Business

I have made a flow that runs every morning at 2 AM to delete rows out of an Excel Online File and imports rows from a SharePoint List. I have a person column titled "Person Responsible" and this column can have multiple people selected in it for a single row. For some reason, when the list gets copied to the excel file it creates two rows when two people are marked in the "Person Responsible" column. One row for the first person, and one row for the second person. 

 

I would like this to just be listed as one row with both people listed in the "Person Responsible" column. 

 

Please help with this duplication issue!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Problem with duplicate rows Using Flow to export SharePoint List to Excel One Drive for Business

Hi @mattroed ,

 

Please refer to the screenshot below to configure Flow.

  • Use variables to append all user names together, separated by semicolons.
  • Then use variables to populate the fields in the table.
  • It should be noted that the variables need to be emptied each time.

Image reference:

12.PNG

Detailed Configuration:

11.PNG

 

Best Regards,

Community Support Team _ Barry
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

4 REPLIES 4
Highlighted
Super User
Super User

Re: Problem with duplicate rows Using Flow to export SharePoint List to Excel One Drive for Business

Hi @mattroed I suspect that you may have a nested loop created by using dynamic data from your list item. Can you please provide a screenshot of your Flow?





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
If you liked my response, please consider giving it a thumbs up. THANKS!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

Highlighted
Frequent Visitor

Re: Problem with duplicate rows Using Flow to export SharePoint List to Excel One Drive for Business


@MattWeston365 wrote:

Hi @mattroed I suspect that you may have a nested loop created by using dynamic data from your list item. Can you please provide a screenshot of your Flow?

 


Flow.PNG

Looks like that is the issue. Any work around so I don't have to use the apply to each twice?

Highlighted
Super User
Super User

Re: Problem with duplicate rows Using Flow to export SharePoint List to Excel One Drive for Business

Hi @mattroed 

 

Easiest way to do this is:

 

#1 - Delete the Responsible Person dynamic content from the Add row into table action

#2 - Move this action out of Apply to each 3 by dragging it directly below

#3 - At the top of your Flow, create a variable, of type string, called "Responsible Persons" or whatever you want it to be called

#4 - Within your Apply to each 3 loop, use the Append to String variable to place just the display name of the Responsible Person into the variable

#5 - In the Add row into table action, use the "Responsible Persons" variable

 

This way, you will still be using the variable to pull out all of the responsible people, but you will only create the row once.





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
If you liked my response, please consider giving it a thumbs up. THANKS!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

Highlighted
Community Support
Community Support

Re: Problem with duplicate rows Using Flow to export SharePoint List to Excel One Drive for Business

Hi @mattroed ,

 

Please refer to the screenshot below to configure Flow.

  • Use variables to append all user names together, separated by semicolons.
  • Then use variables to populate the fields in the table.
  • It should be noted that the variables need to be emptied each time.

Image reference:

12.PNG

Detailed Configuration:

11.PNG

 

Best Regards,

Community Support Team _ Barry
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

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,183)