cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
breid
Helper I
Helper I

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

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.

 

breid_0-1652286927436.png

 

 

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

breid_1-1652285851021.png

 

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @breid ,

 

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

vxiaochenmsft_0-1652671211455.png

vxiaochenmsft_1-1652671221934.png

vxiaochenmsft_2-1652671241429.png

 

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

vxiaochenmsft_3-1652671331849.png

 

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

View solution in original post

2 REPLIES 2
breid
Helper I
Helper I

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.

 

breid_0-1652286635807.png

 

 

v-xiaochen-msft
Community Support
Community Support

Hi @breid ,

 

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

vxiaochenmsft_0-1652671211455.png

vxiaochenmsft_1-1652671221934.png

vxiaochenmsft_2-1652671241429.png

 

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

vxiaochenmsft_3-1652671331849.png

 

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,904)