I am facing an issue filtering an SQL view from Powerapps. When I try to filter the SQL view and create a collection, only the values of columns used to filter the SQL view are populated, if I am not using a column to filter the data, it gives blank value to that column.
For example, SQL_View[column_Name,column_Age,column_EmailAddress] is the view I need to filter and I use ClearCollect(col_colData,Filter(SQL_View,Column_Name="David")), it returns a collection where column_Name is David but all the other columns(column_Age,Column_EmailAddress) are blank.
Instead if I use ClearCollect(col_colData,Filter(SQL_View,Column_Name="David",column_Age="25",column_EmailAddress="firstname.lastname@example.org")), I get a collection with values in all the cloumns.
I do not face this issue when I use a SharePoint list as a data source. Is there any different way to filter SQL data? Also, this happens only if I open the App in a browser using URL. Everything works fine in Preview mode.