Create multiple tables with custom rows from JSON list data in one table

[mcarras]

I'm still learning Power Query in Power BI and a bit confused on how I might approach this...I have a SharePoint List which has two columns that contain lists of JSON records. I'd like to expand each record in these lists into custom rows in a separate table, while also returning a table that represents values from the original SP list. Each JSON record has the same columns. For the new tables, each row should contain information from the original table (ID, Requestor). Something like:

Table A

For each row

For column A, for each list item, take data from JSON record and add a custom row to Table B

For column B, for each list item, take data from JSON record and add a custom row to Table C

Other logic for Table A

Return Table A

I know I will likely need to make custom functions to accomplish this, but I'm not sure how one would insert rows into a table from a query returning a different table. I'm trying to avoid looping over the same SP list multiple times.

[christinepayton]

I'm not entirely sure I'm following, but when I use JSON data in a column, I duplicate the original query, remove all except the row ID and JSON column, then use the "parse JSON" button to parse the data and expand it with the expando-button. Then, when you close and apply, you can relate the two tables on the ID field. Does that help at all?