Here is the flow that could help achieve your desired outcome:
(1) The varEmployeeData variable will be used to store the employee records in JSON format:
(2) The varFieldValues variable will be used to store the field values for each employee:
(3) For the following variable we just need a blank line so just press Enter:
We need this because later in the flow we will be cleaning up the source data and we will need to remote new line characters from the source data
(4) This variable will store your source data. I just pasted in what you had posted:
(5) Next, we use three compose actions to clean up and format your source data:
Here are the expressions for those compose actions:
Here are the expressions that you can copy-and-paste:
(1) Compose Replace NewLine
replace(variables('varSourceDataString'),variables('varNewLine'),'')
(2) Replace Record Separators
replace(outputs('Compose_Replace_NewLine'),'],[',']#[')
(3) Compose Split Employee Records
split(outputs('Replace_Record_Separators'),'#')
(6) Next, add an Apply to Each loop:
(7) Next add a compose action which will separate each employee record from the source string:
split(replace(replace(item(),'[{',''),'}]',''),',')
(8) Next we create the employee record in JSON format:
Here is a close up of the format:
(9) Then add the employee record to the Employee Data. This is the last action of the Apply to each loop
(10) Finally we put all the pieces together into a single JSON object that contains all the employee records inside the Items array:
After the flow is run, the Compose Employee Data contains:
(11) Using a compose action to test the output:
outputs('Compose_Employee_Data')['Items'][0]['FieldValues/Email'] --> krishnendu.barman@abc.com
outputs('Compose_Employee_Data')['Items'][1]['FieldValues/Email'] --> s.hussain.mansuri@abc.com
outputs('Compose_Employee_Data')['Items'][2]['FieldValues/Email'] --> varsha.balu.swami@abc.com
You can reference the other properties using the following expressions:
outputs('Compose_Employee_Data')['Items'][0]['FieldValues/Email'] --> krishnendu.barman@abc.com
outputs('Compose_Employee_Data')['Items'][1]['FieldValues/Email'] --> s.hussain.mansuri@abc.com
outputs('Compose_Employee_Data')['Items'][2]['FieldValues/Email'] --> varsha.balu.swami@abc.com
outputs('Compose_Employee_Data')['Items'][0]['FieldValues/ResponseTime'] --> 48
outputs('Compose_Employee_Data')['Items'][1]['FieldValues/ResponseTime'] --> 25
outputs('Compose_Employee_Data')['Items'][2]['FieldValues/ResponseTime'] --> 43
outputs('Compose_Employee_Data')['Items'][0]['FieldValues/Score'] --> 2
outputs('Compose_Employee_Data')['Items'][1]['FieldValues/Score'] --> 1
outputs('Compose_Employee_Data')['Items'][2]['FieldValues/Score'] --> 2
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
