Join JSON field with data and displaying in SharePoint column

[watson_flow]

Hello, all,

I'm working on a project that pulls data from an outside source via API and populates a SharePoint list. (The source is a report of a form that users fill out to digitize materials.) I made the following flow and it works great! It was a bit tough considering how the JSON is formatted in this case:

 

There are 18 data sets in one data "entry", each headed with number 1-18, so I was able to use the increment function in Power Automate to cycle through these and print what was in the "data" spot.

So, here's my issue. I'm now trying to use this flow for another project, with the source being the same kind of form. (This time it's for requesting to purchase new materials.) The JSON is structured in the same kind of way:

 

However, the source form has been edited over time, so the constant numbers in my expressions will not always bring up the same  information. For instance, although this expression:

body('Parse_JSON')?[variables('n')]?['data']?[4]?['data']

will bring up a "Source Name" in its data field for one entry, it will bring up a "Needed by" date in another. So using this expression isn't going to work.

However, the fieldId is consistent across the board. For instance, in every data set, fieldId number 3228490 will always bring up the Source Name. What I'd like to do is somehow link the fieldId to its data and display it in its respective column. 

I think I need to use Select somehow, but I get stuck pretty fast. And I've tried using an expression like the above to see if I can get Power Automate to display the fieldId--just to throw me a bone--but no dice.

I apologize if this is confusing and if you need any clarification, I'd be more than happy to help. Thank you in advance!

[watson_flow]

Sorry for the post-weekend bump. Just seeing if anyone's got any ideas!

[watson_flow]

Some good news about this problem! I was able to get some things narrowed down with Select:

This gives me the FieldID and its data:

 

But now I'm stuck again. I need to "assign" or link this data to the FieldID so I can populate it to its respective SharePoint list column.

My instinct is just to assign a variable to each of these FieldIDs, but I tried that this morning and it took 18 minutes to complete--only for it to assign the same First & Last name data to each unique FieldID. Ugh.

Any ideas or tips would be greatly appreciated. Thanks!