cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft Employee

UserVoice OData Filter Help!

Has anyone tried the UserVoice template?

 

I can not for the life of me get the OData filter to work. UserVoice has lots of Categories. At the moment the connector will automatically post all new bugs/feature request from UserVoice into VSO. What I'm trying to do is only get 1 category bug/feature request to post into VSO. I have tried lots of different OData filters, but they arent working.

 

https://preview.flow.microsoft.com/en-us/galleries/public/templates/04837470361011e78d1a71a4a5053b4e...

uv-msflow.png

 

1 REPLY 1
Community Support Team
Community Support Team

Re: UserVoice OData Filter Help!

Hi @ VAsHachiRoku,

 

Do you want to only get a specific category request to post into Visual Studio Team Services?

How do you use the OData filters expressions in the Filter Query field?

 

I have made a test on my side, a specific category would have a unique “category_id” , if I fill in expressions in the Filter Query field as screenshots below:

1.png

 

No matter what category the all new request is, I have also tried many other expressions in the Filter Query field, the trigger would always run to post all new request from UserVoice into Visual Studio Team Services.

 

To filter request with a specific category, you could refer to workaround below as an alternative way:  

Suppose the category_id of your request category is equal to “330232”, you could create a flow as steps below:

Note: You could get the category_id of your request category from the run history of your previous flow which runs successfully.

  1. Add a trigger “When an item is created” of Uservoice connector. choose suggestions in the Table name field.
  2. Add a Condition, the first value choose the “category_id” dynamic content of the trigger, the second value “330232”,the condition in the middle choose “is equal to”.
  3. Add action “Create a work item” inside the “If yes” branch of the Condition, fill in the “Account Name”, ”Project Name”, ”Type”, ”Title” and “Description” field.

 2.png

 

When an request is created, and the category_id of your request category is equal to “330232”, the request would be posted into Visual Studio Team Services, and the flow would run successfully as below:

 3.png4.png

 

When an request is created, and the category_id of your request category is “330334”,and not equal to “330232”, the request wouldn’t be posted into Visual Studio Team Services, the flow would run successfully as below:

 

 5.png6.png

 

 

 

 

 

Regards,
Alice Zhang

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 535 members 5,985 guests
Please welcome our newest community members: