Hi @nrd10 ,
Thanks for the extra context. I've redrafted based on using a Person type column in SharePoint that could have multiple persons.
In my revised method, we can remove the need to create the VarPersonintcollect collection. Instead, we can get the data we need using the With function which gives us the same result but is less resource and performance hungry. With that data, we can then use the Office 365 Users connector, but use the User Profile v2 action to get the profile for each email address retrieved inside the With function.
Here is the code:
// Reset collection
Clear(colPersonintcollect);
// Get 'Internal Attendees' email addresses
With(
{
tvData: LookUp(
'Log Interaction_1',
ID = GalleryInteraction.Selected.ID,
'Internal Attendees'
).Email
},
// Loop through to add relevant user profiles to new collection
ForAll(
tvData,
Collect(
colPersonintcollect,
Office365Users.UserProfileV2(Email)
)
)
)
Tested my end, end result is the colPersonincollect collection where I can select any profile information for the users:
------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.
If my response was a good one, please give it a Thumbs Up!
Visit my blog: https://platformsofpower.net
