Not sure what the problem is, but this works. col_UnitDetailsOriginal has data in all columns:
But this does not. the collection only has data in one column.
col_UnitDetailsOriginalFiltered only has data in one column, where the rest of the data go?
Any idea what I did wrong? Thanks.
I don't see anything wrong with your code. Any chance you have rows without data in your data source?
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
Hi @NewBee117 ,
Could you tell me the data type of the fields in your sql table?
I've made a similar test and I found that filter sql data will indeed cause the problem of displaying empty field.
But this problem is not for all data type.
I found that the char type field will not lose data, but others will.
Here's my test for your reference:
Only type in my test is varchar(50) type, its data retains.
As an alternative way, I suggest you filter based on the collection, then it will not occur this kind of problem.
This is the table structure in Azure SQL, it has three fields using nvarchar(50).
My initial try was exactly what you suggested, to create collection1 and then filter collection1, however, I don't get any result after filtering.
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights