Answered

Send an HTTP request to SharePoint to Get multiple Lookup values

(0) Share

Report

Posted on by Chatewarin

Hi all,

I trying to get multiple lookup column by Send an HTTP request to SharePoint but can get only one lookup column.
This picture show Sharepoint list "Code" and "Code:CodeName" are lookup column.

I use "Code/Code&$expand=Code" in front of "CodeName/Code&$expand=Code". It get only Code/Code. When I use "CodeName/Code&$expand=Code" in front of "Code/Code&$expand=Code" that get only Code/CodeName

How can I get Code/Code and Code/CodeName in once time.

Thank you.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report
@Chatewarin i think your REST API should be as follows

$select=Title,Code/Code,Code/CodeName&$expand=Code

Was this reply helpful? Yes No
Chatewarin 34 on at

Like (1)

Report

@annajhaveri Thank you very much.
I understand how to use this solution.

Was this reply helpful? Yes No
Chatewarin 34 on at

Like (0)

Report
Dear @annajhaveri ,

I will ask you more question about http to get sharepoint.
When sharepoint list have 2 lookup column or more than 2 use this solution is fail.

I try to use 2 condition but not work.
$select=Title,BusCompany/ID&$expand=BusCompany,Line/Title&$expand=Line
$select=Title,BusCompany/ID,Line/Title

but when I use 2 condition below flow run successful (I want to get 2 columns)
$select=Title,BusCompany/ID&$expand=BusCompany
$select=Title,Line/Title&$expand=Line
Can I solve this problem ?
Thankyou.

Was this reply helpful? Yes No