cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mtagliaferri
Resolver I
Resolver I

Sharepoint When Item is Created Update Item From Secondary List

Hi,

I have Sharepoint List (e.g. Staff Events) that when creating a new item will update certain info such as staff number and manager, however i need to update two more columns that cannot be updated with the function Get user profile (V2) and Get manager (V2).

I have a secondary list (e.g. Staff Details) that contains the information i need to retrieve and update the new item created, what I am trying to achieve is when creating a new item in Staff Events library it will retrieve Position and Base from the Staff Details library for that particular entry matching either the name or staff number (People Picker for the name or staff number which is a combination of one letter and numbers) and update the Position and Base in the Staff Events library accordingly.

I have come to a complete stand still getting this sorted.

Thanks 

5 REPLIES 5
abm
Super User
Super User

Hi @mtagliaferri 

 

May I ask you that which step you struggling to build the flow? Is that the filter using the people picker?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi  ,

Yes I am filtering via a people picker, but have also tried to filter using the Staff N. which is alphanumerical.

Below is the latest I am trying using Staff N.

F1.JPG

 

The Get user profile & Get Manager work fine and updates correctly the Test 2 list with the staff number.

As the Staff N. has been updated prior to Get items, I presume I can use the Staff number as a filter (u123456 = u123456)

F2.JPG

I am getting the Staff N. from the Get item list

F8.JPG

 

And the Staff N. from the When an item is created list

F9.JPG

 

I then update the list item using the Base Value & the Position Value from the Get items list

F6.JPG

 

Running the flow it returns a false result

F10.JPG

Thanks!

Hi @mtagliaferri 

 

Could you please check the run history of the Staff Number from both action steps? The runtime IF won't show the values what it is comparing.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi @abm ,

can you please clarify? I am pretty ew to PowerAutomate so I am getting confused, What actions should I take? When checking the SharePoint list I can sew that the staff number and the manager have been updated following the first part of the flow.

Hi @mtagliaferri 

 

What I meant is check the run history of your flow and see what values are returned in each step. If you still struggling I could look this via screen share. Let me know.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,574)