Help with Get Items action - Filter Query

[NCMBethC]

First time I'm using the Get Items action and I'm sure I'm just missing something simple...

I have two SharePoint lists:

• NCM-Experience - populated by entries via a Nintex form
• Active Theaters - data listing of all of our theaters to pull info into the Nintex form

I need to pull the selection within the input form into the original list.

For example, user fills out Nintex form and populates Theater Name in the form...this list of Theater Names is actually from the Active Theaters list and is used in the form to filter out the Site Code and DMA based on the selection in that Theater Names column (meaning when they select the theater name, the form auto filters to the right site code and DMA):

In the Active Theaters list, these column headings are:

Theater Name is Name

Site Code is Theater Code

DMA is DMA

And these SharePoint list fields are Lookup fields

All I need is Theater Code selected within the form to show up in the NCM-Experience list in the Site Code column.  

My flow looks like this:

When I tested it, I got this error:

Again, I feel like this should be easy but I am self-teaching myself all of this and would appreciate any help!! 🙂

[Matthy79]

Hello @NCMBethC 

But the error message points to the update statement. Have you checked it? It also says that you try to compare an object with a number. This is of course not possible.

[Nived_Nambiar]

Hi @NCMBethC 

are you using apply to each action as well ?

[NCMBethC]

The rest of my workflow:

then empty fields from the rest of the form and then this:

[Nived_Nambiar]

instead of current item dynamic content, populate it with ID dynamic content 

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Matthy79]

You can't use "Current item" for Id. You have to use the Id value of the current item.

[NCMBethC]

I'm so new I don't know what you mean by update statement or that I tried to compare an object with a number.  Sorry.  It's a lot of self-teaching happening over here. 🙂

[Nived_Nambiar]

Hi @NCMBethC 

ID represent unique id of list item you want to update in NCM experience list in your case, which would be present in the trigger output , so use the ID dynamic content which is present as output of when item is created action to update the corresponding list item 

take this example as reference:

Hope it helps !

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌