Hey everybody I have an interesting case which I unfortunately can't solve maybe someone can help me with it. Background : 1) I have 2 tables in the Sharepoint: - "Line Technology" with columns Line(Choise) and Technology(text).
- "TaskList" with columns 'Task'(Text), 'Technology(Text)', 'Type of the procedure'(Multiple choice), 'Area'(Choice) and 'Feature'(Text). I'm creating the app and the flow is next when the user opens the app he choose the Line. Depending from the line shown label with the technology and on the base of the technology should be displyed available types of the procedures. So the problem now is that 'Type of the procedure' field is a multiple choise field and in the response it gives back table for the each record of the SP list. The question is next how I can filter records in the SP list by Technology and display in the dropdown available types? I was able to display first table with the types from the list but I'm unable to check other records on the availability of the other choises not only those which are available in the first record.
The formula which I use is next: First(ShowColumns(Filter(SDTaskList, Technology = ChooseTech.SelectedText.Value), "TypeofSDprocedure")).TypeofSDprocedure.Value