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.
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
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.
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.
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.