Assuming, your data array is similar to mine, this is easy with a little help from xPath:
Data
[
{"Initative No": "TA1", "BO": "Nancy"},
{"Initative No": "TA2", "PM": "Priya"},
{"Initative No": "TA1", "Approving stakeholder": "Krish", "BA": "Peter"},
{"Initative No": "TA2", "BA": "Jacob"}
]
Select
From
union(
xpath(
xml(json(concat('{"Root":{"Item":', outputs('Data'),'}}'))),
'//Initative_x0020_No/text()'
),
json('[]')
)
Map Initative No
item()
Map BO
first(
xpath(
xml(json(concat('{"Root":{"Item":', outputs('Data'),'}}'))),
concat('//Item[Initative_x0020_No="', item(),'"]/BO/text()')
)
)
Map PM
first(
xpath(
xml(json(concat('{"Root":{"Item":', outputs('Data'),'}}'))),
concat('//Item[Initative_x0020_No="', item(),'"]/PM/text()')
)
)
Map Approving stakeholder
first(
xpath(
xml(json(concat('{"Root":{"Item":', outputs('Data'),'}}'))),
concat('//Item[Initative_x0020_No="', item(),'"]/Approving_x0020_stakeholder/text()')
)
)
Map BA
first(
xpath(
xml(json(concat('{"Root":{"Item":', outputs('Data'),'}}'))),
concat('//Item[Initative_x0020_No="', item(),'"]/BA/text()')
)
)
Create HTML table
body('Select')
