On Create Item, tying to automate lookup value entry from new msg received

[breid]

Hello all,

I am trying to complete a new item in a sharepoint list that was created by "Create Item".  The initial data includes a value in "Title" that I am trying to link to a lookup column by. I cannot seem to copy this "Title" value into the lookup column programmatically.

The lookup column is retrieving the values from the other list in the site only on a manual edit. If I select the lookup value , all the daughter fields populate correctly.

I tried to create custom value like Trim(04-Store#) like below to no avail.

If the value is populated into this lookup column, all subsequent fields are populated, and the next element of automation can be executed with the looked up data.

What can you suggest to get the store ID value into the SiteRef lookup field?

[breid]

here is the SharePoint list I am writing to.  I tried init'ing a variable with the site #, and function (trim(variable) to no avail.

[v-xiaochen-msft · Accepted solution]

Hi @breid ,

The 'SiteRef Id' accepts the ID parameter in the sharepoint list.

So if I want to update a lookup field with 'Test2', I need to enter '2' into 'SiteRef Id'.

You could find the ID with action 'get items' and fill in the 'SiteRef Id' with the ID .

Note: 'get items' action return an array though it may only has one item.

Best Regards,

Wearsky