Power Platform Community Forum Thread Details

SQL - Get Rows action will fail when using Filter Query

Hello,

There is some best practices, or good documents that explain the "Filter Query" option when getting some data?... because I hardly can make it work when using SQL or SharePoint data.

I have a simple task to "sync" a SharePoint list with an SQL database:

But the "Get rows" action will work properly only for a new record in the SP list, when "Get records" will have nothing to return.

If the SP list is updated, meaning the SQL DB will contain an existing record with the same name, the "Get Rows" action fill fail with the following error:

The API 'sql' returned an invalid response for workflow operation 'Get_rows_(V2)' of type 'OpenApiConnection'. Error details: 'The API operation 'GetItems_V2' requires the property 'body/value/0/NameStyle' to be of type 'String' but is of type 'Boolean'.'

I have tried the Filter Query option in different flavors:

CommpanyName eq 'Company 5' (hardcoded company name)

CompanyName eq '@{triggerOutputs()?['body/Title']}' (dynamic company name from SP list)

startswith(CompanyName,'Company 5') (using functions)

But everytime had no luck.

Is there a way to make it work with "Filter Query"?

Kind Regards,

Lucian

Quick Links