Sharepoint When Item is Created Update Item From Secondary List

[mtagliaferri]

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 

[abm]

Hi @mtagliaferri 

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

Thanks

[mtagliaferri]

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.

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)

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

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

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

Running the flow it returns a false result

Thanks!

[abm]

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.

[mtagliaferri]

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.

[abm]

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