Answered

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

(0) Share

Report

Posted on 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!

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Expiscornovus 32,910 Most Valuable Professional on at

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']

Was this reply helpful? Yes No
Community Power Pla... on at

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"

Was this reply helpful? Yes No
Expiscornovus 32,910 Most Valuable Professional on at

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}}

Was this reply helpful? Yes No
Community Power Pla... on at

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!

Was this reply helpful? Yes No