I referred the below article and tried implementing multi level cascading and it works fine but when I use distinct function in the item property of the field Sharepoint Lookup column is not updating
Ref Article : https://powerusers.microsoft.com/t5/Building-Power-Apps/Multiselect-Combobox-Checkbox-in-3-cascading...
Item : Choices([@List Name].Column 1)
On Change :Clear(secondarytest);Collect(secondarytest,Ungroup(ForAll(DataCardValue2.SelectedItems,Filter(FruitType,Fruit=Value).Title),"Value"))
On Chnange :
Column 3 : Items
Trying to use distinct function :
Column 3: Items
When the above code is used the column removes duplicate values but when submitting to SP the data is not saved
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.