cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
debajitkiran
Frequent Visitor

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

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. 

 

5 REPLIES 5
v-sheyu-msft
Community Support
Community Support

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.

14.PNG

 

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

 

Regards,

Eason

Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

 

Thank you,

 

@Anonymous

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
Frequent Visitor

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

Caroline_Jung
Regular Visitor

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 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (1,376)