Power Platform Community Forum Thread Details

I have a dataverse table Table A with columns PromoCycle(primary name coulmn) and a choice column Tiers with choices [Tier1,Tier2,Tier3,Tier4] where i have allowed multiple selections

I have another dataverse table Table B with few other columns ,and i have Cycle Column which is lookup column of PromoCycle from Table A and i have allowed only single selection and another column Tier Applicable (text column).

I have an edit form for Table B where iam entering all values for it

My Tier Applicable (text column) should auto populate the values of Table A Tiers column lets say if i choose Cycle 1 from combobox (DatacardValue6) it should autopopulate/display Tier2,Tier4 in Tier applicable datacard

(It should look for Tiers in Table A for a selected Cycle and display coulmn value in another table 's text input field within edit form)

If i choose Cycle 2 from combobox (DatacardValue6) it should autopopulate/display Tier1 in Tier applicable datacard

what filter condition do i need to write on default property of Tier Applicable datacard/texbox ???

I Tried Filter(Table A, Cycle=DatacardValue6.Selected.PromoCycle).Tiers in default property of Tier Appliacable text box but shows error

please help me with this ?

Categories:

Building Power Apps