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
