How do I fill a Sharepoint Lookup Column in Power Automate?

[johnmarkcausin]

How do I fill a Sharepoint Lookup Column in Power Automate?

I tried using a value that matches one of the options but that did not work.

See screenshot below.

[v-yiwenxie-msft]

Hi @johnmarkcausin 

If you use ‘Get items’ action, then you can only get the lookup items’ Id. The Id is same as the original list’s item Id.

The original list here refers to the list where the lookup item comes from.

So, you can use the flow as below:

If you still have problem with the flow, please feel free to let me know.

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnmarkcausin]

Would this be the column where I will be pulling the data from? or would it be data from MS Forms that can be used to feed into the lookup column.

[v-yiwenxie-msft]

Hi @johnmarkcausin 

It should be data from MS Forms that can be used to feed into the lookup column.

Because the list used in 'Get items' action is the original list where the lookup item comes from.

This filter query is used to check whether the value of the column of original list (which the lookup item value comes from originally) is equal to the data from MS Forms that can be used to feed into the lookup column.

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnmarkcausin]

I am still getting errors. I would like to know if there is a limitation on the value to be used? The data I use for the lookup is an email address captured when users login to MS Forms.

[v-yiwenxie-msft]

Hi @johnmarkcausin 

Could your share the screenshots of your flow to let me spot the errors?

I need more info.

Thanks for your cooperation.

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnmarkcausin]

See Error Details:

[v-yiwenxie-msft]

Hi @johnmarkcausin 

Could you show me the expression you used and the whole flow you created?

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnmarkcausin]

Here is the screenshot of the flows.

[v-yiwenxie-msft]

Hi @johnmarkcausin 

Your 'Filter Query' in 'Get items' action is in a wrong format.

LookupColumn eq the dynamic content

(The 'LookupColumn' is the name of the column)

This filter query is used to match the data from MS Forms that can be used to feed into the lookup column and the column value where you will pull the data from .

For what is filter query, you can go to the link: SharePoint - Connectors | Microsoft Docs

For more info about eq and other operators in filter query, you can go to the link: OData comparison operator reference - Azure Cognitive Search | Microsoft Docs 

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnmarkcausin]

I tried adding the LookupColumn in the Sharepoint site as you instructed but I could only find dynamic contents from MS Forms.

[v-yiwenxie-msft]

Hi @johnmarkcausin 

You don't need to add another LookupColumn in the SharePoint site. Just put in the name of your own lookup column.

The dynamic content to put in after 'eq' is the data from MS Forms that can be used to feed into the lookup column (which is probably the answer of a question whose value can be matched with value from your own lookup column). 

And I've seen that you just got the dynamic content as below. Isn't the value matched with value from your own lookup column respectively? 

First, please make sure that in 'Get items' action, you use the original list which 'LookupColumn' pulls data from.

The data which 'LookupColumn' reference from is in the original list. The 'LookupColumn' is in another list.

Then, it seems like the column name of your lookup column is not LookupColumn?

From the screenshot you posted before, it should be 'Advocate Email CALC'?

If it's still not working, then please go to the list settings> corresponding column> field name:

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnmarkcausin]

now I am not getting any error

I entered: Advocate_x0020_Email_x0020_CALC eq 'Get_response_details'

I had to add apostrophe before and after the dynamic data Get Respondent's Email so I do not get an error when running a test. See screenshot below.

What do I put in this field?

There are my options right now:

btw, thank you for helping out a newbie. 🙂

[v-yiwenxie-msft · Accepted solution]

Hi @johnmarkcausin 

For the field as you shows, please put 'ID' from 'Get items' action as below:

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnmarkcausin]

After following all the guidance given, it still did not work. It was dumbfounding that the Get Items should have been the source List and not the destination. Fixed and working after that. Thank you.