web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Array to output to a S...
Power Automate
Unanswered

Array to output to a Sharepoint multiple value column

(0) ShareShare
ReportReport
Posted on by 81

Hello,
I have 2 Sharepoint lists:

- Skill Teams (Which has skill team names under the "Title" column, and "Department Users" as a People & Group column, where I added the Sharepoint User Group of each department)

- Master Plan Projects Lists

    - Among other columns, I have 2 Look Up columns from the 'Skilll Teams' List:

           - One is called "Lead Organization" (which is obviously for picking which Skill Team is the lead for each project) - This is a single-value lookup column

           - The other one is called "Interdependencies" - a multiple-value lookup column, where we add all Skill Teams that are collaborators on said project.

    - I also created a "Unique Users" column. This is a multiple-value People & Groups column, which I wanted to be a lookup of all User Groups related with the Lead Organization and Interdependencies skill teams. So, if "Marketing" is the lead organization for a project, and "Finance" and "HR" are collaborators on the interdependencies column, the "Unique Users" column would have "Marketing Users Group", "Finance Users Group" and "HR Users Group" as a result. 

 

I am trying to put together a flow to populate the "Unique Users" column when each item is modified.

But I can't seem to get the right flow formula... The flow takes forever to run, and when it does, it doesn't populate the "Unique Users" field correctly. I tried many different combinations, some with partial success, but just can't get it quite right.

Please help!!

 

This is what I put together:

 

 

 

Categories:
I have the same question (0)
  • pperrot1 Profile Picture
    81 on at

    For some reason, my image did not load on my original post:. See below.

     

    Picture1.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard