How to 'Get user profile (V2)' from multiple approvers after Approval and store information in a List per approver?

[Femke1]

Hi everyone,

Hope you can help me with the following situation:

- One person uploads document using Forms and fills in other email addresses (up to 6)

- I want to send an 'Approval' to all the email addresses the person filled in on the Form.

- I have it working until here

But now, after everyone approved, I want to 'Get user profile (V2)' information and store that per approver in different columns in a SP List (for example: DisplayName, givenName, surname, employeeId, mail).

I have no idea where to start... I thought of initializing a variable (array) and get all the profiles in an apply to each (after 'Start and wait for an approval' with an append to array variable), but I'm in doubt on how to split the information afterwards per approver? And I also do not really know how to set this up 🙈

Do you have a clue?

Thanks in advance 🙏

Femke

[Femke1]

I've tried the steps below, but what happens, is that now only the last of the 'apply to each-loop' appears in de column in the list:

- I expected every name to appear in the column (comma seperated - to later separate them to different columns)

- I actually want every name to appear in different columns of the list

Anybody an idea on how to do this?

[Femke1]

I have now put in a Compose action, right after the 'Apply to each' loop:

The output is this: 

{"@odata.context":"https://graph.microsoft.com/.../...(displayName,employeeId,mail,givenName,surname)/$entity ",
"displayName":"Name of Person 1","employeeId":"ID of Person 1","mail":"email of Person 1","givenName":"Given name of Person 1"},
{"@odata.context":"https://graph.microsoft.com/.../...(displayName,employeeId,mail,givenName,surname)/$entity ",
"displayName":"Name of Person 2","employeeId":"ID of Person 2","mail":"mail of Person 2","givenName":"Given name of Person 2","surname":"Surname of Person 2"}

But still... how can I split the info and put it in different columns in a SP List?

[Femke1]

I created a new topic for further assistance.