Unanswered

Field is blank in collection but not in data source?

(0) Share

Report

Posted on by jed76

Can anyone think why when I create a collection from a data source, one of the fields is blank, even though it isn't in the original data source? All other fields are correct, but one of them is blank?! Only think I can spot is that the particular column name has a space between its two names? Could that cause an issue?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jed76 , Can you try using ShowColumn function in you code, example:

ClearCollect(col, ShowColumns(DataSource, "Column1","Column2", "Column3"..."Columnn"))

Does your data source is SQL table?

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
jed76 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. The odd thing is that I can see the column when I view the collection but the field is blank?

Was this reply helpful? Yes No
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@jed76 I understand and that is the reason try to use above suggestion and check the column is showing value or not? For SQL table there were such issues found. Check this:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Collection-columns-empty-when-importing-from-SQL/td-p/610197

https://powerusers.microsoft.com/t5/Building-Power-Apps/ClearCollect-returns-partly-empty-column-values-from-SQL/td-p/1199266

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
jed76 on at

Like
a
(0)

Report
Copy link

Link copied!

I've just restarted the editor and it's working now?! Many thanks.

Was this reply helpful? Yes No