Answered

Expand Lookup field in another SharePoint list using Send Http request to SharePoint

Like (0) Share

Report

Posted on 27 May 2022 15:00:35 by Community Power Pla...

I have a list with 3 columns: Title, Status, Project

I have another list in which I am able to create a lookup column for "Title" from the other list called "Dependencies"; I want to be able to expand and show the other two columns (Status & Project) into this other list using the Send Http Request to SharePoint action in Power Automate

Thanks in advance for any help and let me know if there is any other information I can provide to help!

All responses (4)

Answers (1)

Community Power Pla... on 01 Jun 2022 at 13:27:10

Like (0)

Report

Re: Expand Lookup field in another SharePoint list using Send Http request to SharePoint

Okay great. That seemed to work!

I also found a way to show the column through the flow by adding the following action below in case you wanted to know for yourself also:

Thanks!
Expiscornovus 32,169 Most Valuable Professional on 01 Jun 2022 at 08:19:42

Like (1)

Report
Re: Expand Lookup field in another SharePoint list using Send Http request to SharePoint

Hi @Anonymous,

Your json looks slightly different, I see you have some space characters in the xml part of the body value. Maybe it does not like that xml type of formatting.

Can you try the json below, this is the json I used in my test. (replace the list guid with your guid btw).

{"parameters":{"__metadata":{"type":"SP.XmlSchemaFieldCreationInformation"},"SchemaXml":"<Field DisplayName='Dependencies' Format='Dropdown' Indexed='FALSE' IsModern='TRUE' IsRelationship='FALSE' List='1beb7c31-1417-4715-b719-0288bc04329c' Name='Dependencies' ShowField='Title' Title='Dependencies' Type='Lookup'></Field>","Options":12}}
Community Power Pla... on 31 May 2022 at 15:05:59

Like (0)

Report

Re: Expand Lookup field in another SharePoint list using Send Http request to SharePoint

This is what I have as the body for the first action screenshot that you had (other than the GUID). I have looked at it several times and it looks like it is exactly the same, but I am receiving the error:
"Not well formatted JSON stream.
clientRequestId: b85f2fba-9c2f-43fd-ac2c-3ae249008169
serviceRequestId: 73cc42a0-2080-1000-faa5-c08b7e062767"
Verified answer

Expiscornovus 32,169 Most Valuable Professional on 30 May 2022 at 14:47:11

Like (0)

Report
Re: Expand Lookup field in another SharePoint list using Send Http request to SharePoint

Hi @Anonymous,

You can use the CreateFieldAsXml method for this. That one supports/has a FieldRef property in the xml.

Below is an example of that approach.

In the first HTTP request the reference field gets created. In the second and third request the related fields get linked (in this example the Created and Modified columns from the lookup). This example only adds these fields to the settings. You still have to add them to your view to see them in your view.

For the FieldRef value I used this expression:

body('Send_an_HTTP_request_to_SharePoint')['d']['Id']