You’re offline. This is a read only version of the page.
Announcements
21
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
Hi @Fedir_Redko ,
To better understanding your issue:
1. Which property do you put your formula to? Items property?
2. Do you use dropdown box now? Does the dropdown only show the choices that the first table contains?
3. Do you want to display the multiple selection of 'Type of the procedure' in dropdown box and show all choices in the dropdown list?
You should change to use combo box which support multiple selection, instead of dropdown box, and use Choices() function to display all choices of Types.
Just create a combo box, check "Allow Multiple Selection" property, and set Items as below If no accidents
Choices(SDTaskList.TypeofSDprocedure)
Then set DefaultSelectedItems property as below to display multiple types.
Share
Report
All responses (
Answers (
First(Filter(SDTaskList, Technology = ChooseTech.SelectedText.Value)).TypeofSDprocedure.ValuePlease have a try and check if your issue is fixed.
Best regards,
Sik
