Hello, I am bit stuck here. I am hoping if any one here can assist me on this issue.
User case:
I have a SharePoint list "JobTitleList" that has a Single line text column called "RecipientPosition". The item stored in that column is users job title separated with semicolon " ; ". See the snap shot below.
I have another list "MainList" that stores the users email from there job title in a people picker column by using power automate. "Allow multiple selection" is enable in the people picker column. See snapshot below.
I was able to get the users detail by there Job title using Microsoft Graph API. But I was not able to associate each user jobtitle to the the recipient people picker column in another list. Here is what I did to get those values. See the screen shot below as well.
I hope this diagram might help to understand. I think my explanation might be complicated to understand.
1 is First Loop Apply to each 9
2 is nested loop under Apply to each 9
The below snap shot is inside the "Parent Loop Apply to each 9" On this section, Since I am using Append to array trigger, its appending the duplication values from nested loop. Example,
First Parent Apply to each 9 loop give me two values,
[
{"Claims": "UserEmail1"},
{"Claims": "UserEmail2"}
]
The second loop with in Apply to each 9 loop gives me 4 values including the values of 1st loop.
[
{"Claims": "UserEmail1"},
{"Claims": "UserEmail2"},
{"Claims": "UserEmail3"},
{"Claims": "UserEmail4"}
]
How would I remove the duplication values from the loop so that I can get unique value for each loop?
I took me while to formulate this question. Don't know if I made my statement clear. But I am looking to see if any one can help me out here.
Thanks
I think i got the cause of the issue.
The array to which you are appending the user email values should be set as empty before starting of next iteration from parent level. You can place set variable action with setting the array variable as empty before the split operation. So that it won't take the previous iteration values.
Hope it helps !
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌