I have a flow that when a record is created in the dynamics Account, the same item will create in the Sharepoint list
I have a list of cities in both systems as a lookup column. Obviously in dynamics city has GUID and SharePoint has ID.
How I can get the ID from GUID?
For example, when I create a new Account in dynamics I choose "city1" as a city and need to pass the id of "city1" to the SharePoint list to create that item.
Can anybody help me?