Power Platform Community Forum Thread Details

Issue with Combobox

Hello,

I have a combobox to which I want to give a default value based on whether an item from a gallery is selected. Items come from a sharepoint list. There are a few sharepoint lists connected, ID is the linkage between them.

Now, if I filter the associated SharePoint list SPO_List_BBP_Personne_Auditee selecting the BBP_Main_BBP_Id (a lookup column) equal to the main list ID directly from the DefaultSelectedItems of the combobox, like below, it always returns zero rows. Please note that I have very small lists, so delegation is not an issue:

If(

    !IsBlank(gloSelectedBBP),
ForAll(
      Filter(
            SPO_List_BBP_Personne_Auditee,
            BBP_Main_BBP_Id.Id = ID
        ),
{
    
    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    Email: ThisRecord.Audited_Person.Email,
    Claims: "i:0#.f|membership|" & ThisRecord.Audited_Person.Email,
    DisplayName: ThisRecord.Audited_Person.DisplayName
    
}
))
 
If, instead, I collect the same filtered list from the gallery page in "OnSelect" like so:
 
    ClearCollect(

        colAuditedPeople,

        Filter(

            SPO_List_BBP_Personne_Auditee,

            BBP_Main_BBP_Id.Id = ThisItem.ID

        )

    )
 
and then I pass the "colAuditedPeople" instead in the DefaultSelectedItems, it works without issues.
The "gloSelectedBBP" works well, ID is what it should be... I am at a loss.. Is there an evident explanation I am not thinking of?
 
Thanks a lot.
Kind regards
Valeria
 
 
 
 
 