Power Platform Community Forum Thread Details

Hello All,

I am currently making a Power App based on existing SharePoint lists that were created in a sub optimal way. I have the following lists, FRUIT, TREES, and FRUIT_to_TREES. FRUIT_to_TREES is a helper table that has only two text columns of the Title column of both other tables, this is to allow a many to many relationships. What I need to do is create a gallery to do the following. I also need all options to be delegable to SharePoint.

1. Filter the table FRUIT_to_TREES

2. In FRUIT_to_TREES filter on the Fruit collum only those records that a variable called var_selected_fruit

3. If the combo box comb_ripeness has a selected value, Filter on the List Trees on a lookup collum called ripeness for records that match comb_ripeness.

My current formula that does not work is listed below:

Filter(
 FRUIT_to_TREES,
 var_selected_fruit_fruit=var_selected_fruit.Title)
&&
If(
 IsBlank(comb_ripeness.Selected.Title),
 true,
 Filter(
 TREES,
 StartsWith(
 ripeness,
 comb_ripeness.Selected.Title
		)
 )
)

Categories:

Building Power Apps