Power Platform Community Forum Thread Details

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/notify-your-team-and-log-feature-requests/

Categories:

Using connectors

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:

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.

Add a trigger “When an item is created” of Uservoice connector. choose suggestions in the Table name field.
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”.
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.

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:

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: