
So I've done my fair share of developing workflows in power automate. Boss has requested a project I'm currently struggling a little bit with. We have created a synchronization list that contains a source URL, source list name, destination URL, and destination name. What we are trying to figure out is how do we setup power automate to GET the items from source URL\Source List Name and POST the same items to the destination URL\destination name from within the synchronization list.
I would try to use variables and format them accordingly to put into Custom Values for things like Site Address or List Name in different steps like HTTP Request and then Get Items.
Could you Get Items on your sync list.
Start an Apply to Each
Compose/Set a Variable to the Source Url that doesn't have the list name.
Put SourceURLVariable into HTTP Request as the Site Address with an api/web/lists/GetbyTitle('VariableSourceListName')?$select=Id.
Put the listId into a variable.
Use a Get Items that has Custom Value of Site Address and put the listIdvariable in as the List Name
Use that Get Items result to post into the destination URL
That is just quick brainstorming to get started, the rest of the work would be some kind of Batch post that I'm guessing you know how to do already.
Basically my idea is to chop up the values to put variables that can be used in other steps.