BUTTON LOADING EMPTY RECORDS INTO COLLECTION - ONLY ONE RECORD IN LIST

[chudson002]

Good morning, 

Have an app where a collection is loaded on the click of a button. There is only one record in the SharePoint list.  When button is clicked, it loads not only the one record, but it also loads empty records.  What could be causing the empty records to load?  

Thanks,

V/R

chudson002

[#2]

Hi, you can use a filter when you create a collection to limit the records is contains. For example: ClearCollect(col_collection_names, Filter(sharepoint_list_name,sharepoint_list_field_name.Value<>""));

[#3]

@chudson002 Can you show the formula you used for collection? 

Use ClearCollect() function in formula like this: 

ClearCollect(myCollection, SPListDataSourceName);

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.