Forum Discussion

chudson002's avatar
chudson002
Brass Contributor
Nov 19, 2022

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

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

 

Collections
loading issue
PowerApps
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Nov 21, 2022

    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.

  • jonlake's avatar
    jonlake
    Iron Contributor
    Nov 20, 2022
    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<>""));

Resources