Answered

Get items filter query Copilot Studio

(0) Share

Report

Posted on by niklasjegg

505

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

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (8)

Answers (2)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
niklasjegg 505 on at

Like (0)

Report

Hi @Pstork1 ,

okay so would this look something like this?
im still getting an Error from the get items action.

Was this reply helpful? Yes No
niklasjegg 505 on at

Like (0)

Report

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...

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
niklasjegg 505 on at

Like (0)

Report

Hi @Pstork1 im sorry yes i also tried this.

But sad enough still getting a generic error.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
niklasjegg 505 on at

Like (0)

Report

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!

Was this reply helpful? Yes No