My biggest challenge at this time is filtering a collection from a value in another colllection.
1) I create collections one
1- ClearCollect(CableNumbers,('Cable Trace Form'.CableNumber));
2) I want to use the value from CableNumber that the user chooses and filter a second collection by that value
2 - ClearCollect(CableFrom,('Cable From'.FromDescription),('Cable From'.CableFrom),('Cable From'.CableNum));
Collection 1 is working as expected, but how do i go foward and create a second filter based off of the chosen value in Collection 1?
This is my issue and any suggestion would be appreciated. I've been trying to set it up without success.
Thanks for this reply. The value i want to filter on is in a selected value in a drop down, not in a gallery. how would I use this formula if I wanted it to filter off of the object picked in the drop down?
I tried your code you've included here and though it's not failing, how would find the data based on the speicific entry chosen?
If you want to filter based on selected value in a dropdown change your filter function to this:
Filter( CableForm, CableNum = DropDown.Selected.Value )
I am not sure if I understood what you want to do correctly, maybe a screenshot would help?
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights