Hopefully this will get what you're looking for. I used some XPath expressions to convert the data to an array of objects. I'm assuming you want to add only certain fields to your CSV table.
See full flow below. I'll go into each of the actions.
Compose contains some sample data, in a similar structure to yours. I want to extract out the Name and Age into my CSV table. You would like want the DisplayName, Email, etc. from your data.
Create CSV table uses the following expressions to extract out the data (Name, Age).
//From
xpath(xml(json(concat('{"root": ', outputs('Compose'), '}'))), '//root/*')
//Name
xpath(item(), 'string(/*/Name/text())')
//Age
xpath(item(), 'number(/*/Age/text())')
//You would use something like the following for your data
xpath(item(), 'string(/*/DisplayName/text())')
xpath(item(), 'string(/*/Email/text())')
xpath(item(), 'string(/*/Department/text())')
xpath(item(), 'string(/*/JobTitle/text())')
After running my flow, I would have the following CSV table.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
