Is there a way to merge 'Get items' from 2 SharePoint lists?

[JHersch77]

I have a Power Automate that gets items from 2 SharePoint lists, creates html tables and emails them on a daily basis.  I am having no luck finding a way to either merge the 2 'get items' steps or merging the 2 'create html tables' steps.  I would like both in 1 table.

Is there a way to merge the data from 2 separate 'get items'?  

[lbendlin]

What condition would you like to merge the tables on?

[JHersch77]

Not sure I understand, but I should clarify my process

1. Get items from SharePoint list

2. Create html table with 3 columns

3. Get items from ANOTHER sp list

4. Create html table with same 3 columns

5. Email both tables

The issue I have is the columns don't align in the email, and it looks bad.  I've tried CSS to give the columns width using td last-child, but that doesn't work.  so I thought that if I could merge the 'get items' arrays or the html tables, they would all be in the same table and look nice.  Maybe there is an easier way that what I am thinking.  Thanks!

[lbendlin]

That means you want to "zip"  the lists rather than merge.  Basically combine them based on the row number.

1. get items from first list

2. get items from second list

3. get row count  (hopefully they are the same!!!)

4. iterate through all rows. Collect the three fields from that row in list1, the three fields from list 2,  and stuff them into your html table row.

5. add table header and footer as needed.

6. send email.

[JHersch77]

Thank you, but I should have specified lists 1 and lists 2 are different lists with different information,  List 1 could have 3 items, list two can have 33 items, etc.. they vary day to day, but when I email them the columns are not the same width

List1

Event      | Description    |   Link                                         |

List2 

Event                      | Description             |Link                   |

I know its just formatting, but I would rather merge the items in both lists for 1 table vs 2 tables

Lists

Event    | Description  | Title  |

I feel like there is an easy way and I am guessing I am not using the best terminology hence not finding a solution...thanks again for your patience!

[lbendlin]

In this case the terminology would be "append", not "merge"

1. get items from first list

2. get items from second list

3. create a new text variable to hold the HTML code for the table rows.

4. iterate through all rows, first from the first list, then from the second list, Stuff into the variable .

5. add table header and footer as needed.

6. send email with table header, variable, table footer.

[JHersch77]

ok, thanks.  So, can you append output Get Items with another Get Items or append 2 Create HTML actions

I guess like you mentioned, I could manually build the table, but I am using create html table actions.

[lbendlin · Accepted solution]

I don't think that will help you as you will end up with different column widths again.  Create the table HTML manually.

[jherschel7]

Got it.  Thank you very much!