Merging two or more Array variables for a single HTML table gives unevenly saved data

[arindam40]

Hi Team,

I created a Power Automate flow, where in users are added or removed into Office365 groups, passed from a Excel table saved in SharePoint Online. In different conditions, either user added, or user already existing in the group or removed from group, I have setup append array variables at the end of each loops which saves dynamic data to its connect array variables.

In the second part, I am trying to merge all these array variables together, which basically has one column each based on user added or removed or exists find of condition with few user principal names.

Hence all my variables have single column which I need to merge together with all data saved to it. My plan is, to collect the combined data & create an HTML table to send emails.

I am successful in merging the data & placing it in table, but data is saved unevenly in the table. I am attaching the screenshots here. These are list of variables saved as in variables1.jpg.

File1.jpg will show that I used Union() function in Compose to add 3 such variables together. With Compose output I have setup a filter array to combine all columns that doesn't exist, as shows in File1.jpg. Eventually I created an HTML table as in File1.jpg.

The data for email with a style sheet returns like as it shows in tab2.jpg.

As you can see, the second column data shows up, after 5 rows after first row finishes. What am I missing here?

Any help will be great.

Thanks

Arindam

 

 

 

 

 

[SudeepGhatakNZ]

You could create two separate Create HTML tables one for Active Users and one for Inactive Users and place them inside a div.

<div>
    <div style='float:left'> You active user table goes here</div>
    <div> Your inactive user table goes here</div>
</div>

[arindam40]

Hi Sudeep,

Thanks for replying back. I tried your method, but that brings the data vertically down one column below another. Not in a a table format.

I tried modifying a bit:

<div class="row">
  <div class="column"></div>
  <div class="column"></div>
</div>

But same results. Its not creating tables, instead each column listing one after another.

In my solution, I had it saved in the table, in HTML table format. But the second column starts leaving 5 rows after 1st column data finishes. Is there a way to make sure that column data starts from the top?

Thanks

Arindam

[SudeepGhatakNZ]

Let me try that at my end

[SudeepGhatakNZ]

@arindam40 

Please check the HTML tags at your end. It works for me just fine.

I have attached a sample.

[arindam40]

Hi Sudeep,

Just using the HTML tag you provided, its not working. The tables get placed vertically. Not setting table at all. Any other way to force this?

I just wanted to show you, I found another complain in the same community with same issue as mine. Might be of some help referencing.

https://powerusers.microsoft.com/t5/Building-Flows/Power-Automate-Create-HTML-Table-rows-staggered-a...

Thanks for all your help.

Thanks

Arindam

[SudeepGhatakNZ]

@arindam40 ,

Did you import the flow I provided?

Alternately, please share the HTML generated in your email. It could just be a tag causing the issue

[arindam40]

Hi Sudeep,

Sorry, I did not realize there was an attachment. I have imported the test flow now. Let me check & revert back.

Thank you very much.

Thanks

Arindam

[arindam40]

Hi Sudeep,

Tried your solution, exactly as you mentioned. But the columns are not setting up as a table. Instead its showing up in the email one after another. Mail setup from the output, but same result.

Attaching snapshots.

Thanks

Arindam

 

 

 

[SudeepGhatakNZ]

Are you available for team's call?

[arindam40]

Yes I am here Sudeep. Do you need my email to connect?

Thanks

Arindam

[SudeepGhatakNZ]

Sent you a private message

[SudeepGhatakNZ]

@arindam40 

Change your HTML structure as shown below.

It works!

[arindam40]

Hi Sudeep,

Thanks for replying back. I changed the HTML structure as you suggested. Its better, but columns are still not aligned. My final HTML structure composed is this:

<body>
<table>
<tr>
<th>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</th>
</tr>
</table>
</body>

All 6 variables captured. But column headers not aligned. 

Thanks

Arindam

 

[SudeepGhatakNZ]

Can you send me the resulting HTML?

[arindam40]

Hi Sudeep,

Thanks for replying back. I am sending the HTML data after run & the compose setup for HTML that I created in the Flow. Added few tags here & there, but no changes.

Thanks

Arindam

 

 

[SudeepGhatakNZ]

I just need the HTML so that I copy it and test it at my end. You can get rid of any confidential data.

[arindam40]

Hi Sudeep,

My HTML tables are getting data from the composed ones which are again getting data from each variables. Which one should I send you?

Thanks
Arindam

[SudeepGhatakNZ]

HTML that goes inside the email in RUN mode

[arindam40]

Hi Sudeep,

Its all connected with one another. Just sending one might not work, Basically you would need many items. Can we setup a Teams meeting like yesterday? It will be easy to collect data that way.

Thanks

Arindam