Powerbi table duplication with automation

[apenyaranda1985]

Hello, I have a word where I have created a table with two rows, one of them is repetitive and with two fields from a powerbi table. Then with power automate I make it collect rows from the powerbi table and put them in a word, the problem is that it duplicates data.
It does everything right for me but it always repeats the entire table twice, if the table has a total of two rows, it creates four, if it has one, it creates two... always like that and I don't know why that is.

In fact, at the exit of the loop, it collects each row only once (in the example in the screenshot it only has one row) but when it comes to collecting that data with Populate a Microsoft Word Template, it already collects it twice.

Any ideas?

[v-yueyun-msft]

Hi , @apenyaranda1985 

According to your screenshot , i think you do not need to use the apply to each action outside of your "Append to array variable" action.

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[apenyaranda1985]

I have modified the following but it does the same thing. It is curious that the first phase collects the data well (once) and the next phase duplicates it.
Anyway, I don't quite understand what you mean in your previous comment.

[v-yueyun-msft]

Hi , @apenyaranda1985 

Thanks for your quick response! This seems has no error , what do you mean about "the next phase duplicates it."?

Can you show your flow run history where duplicates?

Best Regards,

Yueyun Zhang

[apenyaranda1985]

As you can see, in the repetition phase to collect values from the table, it collects them well, it brings only one row (the example I use is a single row. I attach the table that I want to bring.)

But in the second phase "Populate microsoft word template" it already duplicates it and I don't know why.

Table powerbi:

[v-yueyun-msft · Accepted solution]

Hi , @apenyaranda1985 

Can you show your initialize variable configuration in your side? This is strange , Based on your screenshots, it is true that only one append to the array was performed...

Dose your flow have more append to array variable action?

And can you add a compose action to test the variable return in your side, like this:

Best Regards,

Yueyun Zhang

[apenyaranda1985]

I already found the problem thanks to a comment from you, I had the variable initialized with the data from the table, I imagine that later I did the data collection, that is, I already had the duplicate data.
Many thanks for everything!

[apenyaranda1985]

Sorry, a couple of things that affect me in this process.
1. Is there a possibility of formatting the data it collects?
2. Is there a possibility that in one of the columns you can add the total right at the end?
thank you.

[v-yueyun-msft]

Hi , @apenyaranda1985 

Thanks for your response.

1) If you want to format the headers name for an array , you can use "Select" action.

Use data operations in Power Automate (contains video) - Power Automate | Microsoft Learn

If you want to format the value , you may need to use the expression.

Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

2) If you want to add another column in the end , you may need to calculate and add a property to the array object in Flow.

In a general forum, one case solves one problem. For your problem, you can create a new case so that more people will help you. I'm getting off work today! Thank you for using Microsoft products!

Best Regards,

Yueyun Zhang