While inserting a record from sharepoint to Azure SQL,I have so many Lookup fields. I have to get the id's of selected field. For ex I have a country Field. I have to get id of (selected or typed) country and that id should be placed into the table. How i can achieve this.
Please guide me on this.
@CFernandes :Please help me on this.
Hi @Murari ,
When it comes to lookup columns 'Get items' is the action should be your friend.
It should return you the 'value' array from which you can get the properties.