Get items filter query Copilot Studio

[niklasjegg]

Hi, i am trying to create a Topic that collects User Input and finds a specific item in a Sharepoint list with the get items Connector action. I cannot wrap my head around how to build the filter Query for this. 


Normally i would use the query  InventoryNr eq and the variable from the User Input.

How can i achive this here. The system wont let me input another line of text or something... 

Thanks for the help. BR Niklas

[Pstork1]

You still use the same kind of OData query. If you don't want the user to actually type the query in using that format you would need to use the set variable functionality to build out the appropriate query.  Then use that variable as the query.

[niklasjegg]

Hi @Pstork1 ,

okay so would this look something like this? 

im still getting an Error from the get items action.

[niklasjegg]

So i have tested this again and came to a conclusion:

Copilot Studio is doing this wrong: 

The Set Variable action does not work! If i output the variable in the same manner {Topic.ItemName} as a text message it works fine. 

If i manually write my query in the Get Items action it also works so my SPO Column is also correct...

[Pstork1]

That looks correct except for the missing quotes around Topic.ItemName, In an OData query for a string you need to surround the value with single or double quotes. You may also need to use a Power FX concatenate to build the string instead of just typing it in when using a variable.

[niklasjegg]

Hi @Pstork1  im sorry yes i also tried this.

But sad enough still getting a generic error.

[Pstork1 · Accepted solution]

I'm having issues getting it to work also, but I am getting what looks to be a valid query string.  As I mentioned you need to use concatenate and add punctuation.  Like this.

This is what the query output string looks like

[Pstork1 · Accepted solution]

Trying again, I still couldn't get it to work as a plugin, but using the connector action it worked the way I expected it to. From what I've been told the Plugin is really designed more for direct APIs rather than using the pre-built connectors.  But using the variable I created in the previous screenshots my OData query on the Title field worked.

[niklasjegg]

Hi @Pstork1  oh my this is a task. I don´t get it why someone decides to make it this complicated. I am sorry i missed the concatenate part there 🙂 I am fine with the connector action haha. 

Also working now thanks a lot!