Creating a lookup column in a list

[arturdjali]

Hi All,

i am trying to create a lookup column for a new list i am creating using the http request. I believe i've got most of it setup but im not sure on the json need to all for multiple fields in this case ID and essionDuration.

This is the column i'm trying to replace in flow:

this is how it looks in the flow:

any help is appreciated.

thank you 

[Expiscornovus]

Hi @arturdjali,

You could use the CreateFieldAsXml method for the creation of a lookup field. 

Try something like below:

{"parameters":{"__metadata":{"type":"SP.XmlSchemaFieldCreationInformation"},"SchemaXml":"<Field DisplayName='Course' Format='Dropdown' Indexed='FALSE' IsModern='TRUE' IsRelationship='FALSE' List='@{variables('LookupListGUID')}' Name='Course' ShowField='Title' Title='Course' Type='Lookup'></Field>","Options":12}}

[arturdjali]

Hi @Expiscornovus ,

This works perfectly for creating the lookup column, my only other question what change would i need to make to select columns to show ID and SessionDuration?

Thank you

[Expiscornovus · Accepted solution]

Hi @arturdjali,

You can use the FieldRef property in two other requests with the same CreateFieldAs Xml method. You can reuse the Id from the output of your first request to reference the lookup field in your second and third request.

Below is an example.

{"parameters":{"__metadata":{"type":"SP.XmlSchemaFieldCreationInformation"},"SchemaXml":"<Field DisplayName='Course: ID' FieldRef='@{body('Send_an_HTTP_request_to_SharePoint')['d']['Id']}' Format='Dropdown' IsModern='TRUE' List='@{variables('LookupListGUID')}' Name='Course: ID' ShowField='ID' Title='Course: ID' Type='Lookup'></Field>"}}

[arturdjali]

@Expiscornovus  Thank you! That does the trick.