cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
beatlefreak
Helper I
Helper I

Lookup another list to update items

I have two SP lists: OrgChart & EventList.

 

OrgChart

users(person column)Tier1Tier2
AClass1Class1-a
BClass1Class1-b
CClass2Class2-a
DClass3Class3-a

 

 

EventList

EventNameParticipants(multiple person column)Created ByTier1Tier2
event1A, B, CA  
event2

B

D  
event3C, DB  

 

 

So whenever someone creates item on EventList, I want to populate EventList Tier1 and Tier2 with information of both Participants and CreatedBy from OrgChart.

 

So for example for event1 on EventList, Tier 1 should be filled with "Class1, Class2" and Tier 2 should be filled with "Class1-a, Class1-b, Class2-a"....

 

Any help....? Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
v-liwei-msft
Community Support
Community Support

Hi @beatlefreak 

 

According to your needs, I made a test for your reference:

1.

vliweimsft_0-1670388146227.png

vliweimsft_1-1670388156236.png

2.

vliweimsft_2-1670388170286.png

3.

vliweimsft_3-1670388184323.png

4.

vliweimsft_4-1670388196823.png

5.

vliweimsft_5-1670388210339.png

vliweimsft_6-1670388219876.png

 

 

Best Regards,

Levi

 

 

 

 

View solution in original post

2 REPLIES 2
v-liwei-msft
Community Support
Community Support

Hi @beatlefreak 

 

According to your needs, I made a test for your reference:

1.

vliweimsft_0-1670388146227.png

vliweimsft_1-1670388156236.png

2.

vliweimsft_2-1670388170286.png

3.

vliweimsft_3-1670388184323.png

4.

vliweimsft_4-1670388196823.png

5.

vliweimsft_5-1670388210339.png

vliweimsft_6-1670388219876.png

 

 

Best Regards,

Levi

 

 

 

 

thank you so much.....you are amazing!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,830)