cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How to get lookup value while in flow

Hi All,

     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.

4 REPLIES 4
Highlighted
Resident Rockstar
Resident Rockstar

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. 

 

 

 

 

 

Highlighted

Can you suggest with an example.

Highlighted
Frequent Visitor

Waiting for your valuable suggestions.

Highlighted

@Murari  Just have a look at the video: https://www.youtube.com/watch?v=bTqWrM1p_WI

 

It should help you achieve you requirement. If you still get stuck we can think of plan B. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (11,805)