cancel
Showing results for 
Search instead for 
Did you mean: 

Get rows SQL, filter ODATA with a boolean field

Hi,

 

Dealing with SQL (on premises or Azure) is a great way to automate processes or generate reports over big amount of data.

However due to some limitations sometimes it's hard to isolate data. I've come acrosse to the unability to filter boolean fields on action "Get rows SQL" Odata Filter.

 

It's a simple feature (i think) with a big impact on users who more and more try to relate Flow and Sql.

 

Please do not link this feature only to SQL on Azure. I undersand Microsoft commercial speaking, gives some priority to SQL on Azure  instead of SQL on premises, but you must take into consideration most of ERP nowadays working with SQL don't have yet the feature to transfer the data to Azure. It's not user choice, but provider limitation.

 

Thanks

 

Status: New
Comments
Level: Power Up

@moutinhoabreu wrote:

Hi,

 

Dealing with SQL (on premises or Azure) is a great way to automate processes or generate reports over big amount of data.

However due to some limitations sometimes it's hard to isolate data. I've come acrosse to the unability to filter boolean fields on action "Get rows SQL" Odata Filter.

 

It's a simple feature (i think) with a big impact on users who more and more try to relate Flow and Sql.

 

Please do not link this feature only to SQL on Azure. I undersand Microsoft commercial speaking, gives some priority to SQL on Azure  instead of SQL on premises, but you must take into consideration most of ERP nowadays working with SQL don't have yet the feature to transfer the data to Azure. It's not user choice, but provider limitation.

 

Thanks

Need this for Dynamics 365 CE