Power Platform Community Forum Thread Details

Hi. I am building new screen and I have Entity and Segment as filters to show me my customer list. My formula for items is

If(!IsBlank(DataCardValue4.Selected)&&!IsBlank(DataCardValue127.SelectedText),Distinct(Filter(CustomerList,Entity=DataCardValue4.Selected.Value&&Segment=DataCardValue127.SelectedText.Value),Customer),If(!IsBlank(DataCardValue4.Selected),Distinct(Filter(CustomerList,Entity=DataCardValue4.Selected.Value),Customer),If(!IsBlank(DataCardValue127.SelectedText),Distinct(Filter(CustomerList,Segment=DataCardValue127.SelectedText.Value),Customer),Blank())))

However, it shows me warning sign. What is wrong here? I have Entity as a choice in my sharepoint list, and segment as a text.

I also would like to have all customers selected as a default, is there any formula for it?

thanks for all!