Clear dropdown selected items on changing of another dropdown - In Sharepoint forms

[debajitkiran]

Hello Everyone,

I am using powerapps form with a SharePoint list. In my list have 2 lookup fields ( Entity & Organisation ) which are loaded as combo box in the powerapps forms.

Combo_entity : points to Sharepoint lookup field Entity

Combo_org : points to Sharepoint lookup field Organisation

now I want to clear up selected value of Combo_org , on changing of Combo_entity, I am doing Reset(Combo_org) OnChange of Combo_entity , but it is not clearing up the control.

Seeking your help on this regard. Many thanks in advance. 

[v-sheyu-msft]

Hi @debajitkiran,

Can you share a bit more about your issue ?

Do you mean the customize App in SharePoint list ?

Can you show me the DefaultSelectedItems property of Com_org ?

I made a test . There’s no issue on my side.

Please check if the DefaultSelectedItems property of Combo_org is set to a fixed value.

Regards,

Eason

[Anonymous]

Thank you for your post @debajitkiran. Can you review the latest reply and update the thread?

Thank you,

@Anonymous

[debajitkiran]

Hello,

I have tried creating sharepoint forms using Powerapps. Screenshot attached 

In the New Form it is working , but in the edit form the reset is not working. Is this a powerapps bug ?

Thanks

Debajit

[yogeshkumarPa]

Make sure you have not set DefaultSelectedItems property or set it conditionally.

[Caroline_Jung]

I had the same issue.

I resolved it by setting DefaultSelectedItems of Combo_org with this formula:

If(
    IsEmpty(
        LookUp(
            Filter(
                Organisations;
                lkpEntity.Value = Combo_entity_DataCardValue.Selected.Value
            );
            Title = ThisItem.Organisation.Value
        )
    );
    {
        Id: -1;
        Value: Blank()
    };
    LookUp(
        Filter(
            Organisations;
            lkpEntity.Value = Combo_entity_DataCardValue.Selected.Value
        );
        Title = ThisItem.Organisation.Value
    )
)

Hope this helps someone