Hi everyone, I have built an app using one of Reza Dorani's videos as guidance in whhich he has created list of projects and a list of tasks related to each of the projects using a lookup column.
For my app, I have a sharepoint list of 'Risks' and another list of 'Treatments'. The treatments are assigned to a risk which help to reduce the risk and there is a lookup column in the treatments list where you can link them to a risk.
I have a drop down box where you select the risk and then when you go to the treatments page it brings up the treatments in a gallery. It works great if the lookup column doesn't allow multiple selection, however, there are treatments which could apply to multiple risks and I would like to be able to do that.
On my treatments page I am using the OnVisible property with the code ClearCollect(colGridData,Filter(Treatments,'Risk lookup'.Value = RiskSelection.Selected.Title)) but as soon as I change the list column to allow multiple selection, I get an error saying I am comparing a table with text. I am sure it's a simple fix but beyong my level of knowledge so any help would be greatly appreciated!
