How to update SP list by using another SP list items

[Anonymous]

Hi all...

I have a question when it comes to updating an SP list based on items in another SP list. 

I have two SP lists right now (SP List 1 & SP List 2), SP list 1 contains my data that is used in my PowerApps and SP List 2 is a list that contains submitted form in my PowerApps.

I want to make a flow that gonna automatically change/update an item from SP list 1 based on the SP list 2 columns that contain a date. By using that date, I want to use Delay Until the date from SP list 2.

I already read the solution from https://powerusers.microsoft.com/t5/General-Power-Automate/MS-Flow-Using-a-SP-List-to-update-a-Diffe... but the solution said the need to create an ID for identifying the same items. In my SP list 2, because I know every time I submit a new form, the ID will be different than the ID from my SP list 1.

Is there a way to find the item in SP List 1 from any items in my SP List 2? 

Thanks in advance.

[v-litu-msft · Accepted solution]

Hi @Anonymous,

The ID is not the system ID, you could create a custom ID like PowerAppsID in the two SharePoint list. Then use the PowerApps ID as the unique ID to update the item in the other SharePoint list when one of the SharePoint list update.

To make the ID unique, you could consider use the GUID() function to generate a unique ID when creating new items in two SharePoint lists.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-litu-msft, thank you for your reply, I'm sorry but seems I gonna describe the whole thing.

The idea of why I want to implement this is because I am building an application for Leave Request. Everything is running well, but I still need a function for automatically changes the status of someone who requesting on leave (On Leave or Actively Working)

I get the idea from your reply that I can use the random generated ID in each SP list so every time an item is created, the Flow will use that random ID from the item then update the items from another SP list. But one of my SP lists does not change until I add or subtract the data contents in the SP list at any time, while in the second SP list is a place to store data from forms submitted from my application and this will continue to happen as long as someone submitting a leave request.

I was thinking if I can use the employee ID number as a unique ID because it's one of the same data between the two SP list but I still don't know how to utilize it. Is there any advice on this problem?

Thanks.

[v-litu-msft · Accepted solution]

Hi @Anonymous,

You could also use the Employee ID as key value of the two lists as long as they are unique.

If you want to sync the two lists, you could create a similar Flow with trigger When an item is created or updated, as long as one item in the SharePoint list update, update the other list.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-litu-msft,

I already try to set my Employee ID to be the unique identifier number, but I still can't set them right, I also try to search 'how to' but still can't find the right one. Can you help me give some explanation or at least the right link so I can learn from it?

Thanks.

[Anonymous]

Hi @v-litu-msft 

Thank you for each of your replies, which gave me an insight into finding the best way to solve my problems.