Dropdown doesn't show values
12-27-2018 12:04 AM
I'm creating a helpdesk app and I'm currently creating search functionality. I currently have following setup:
1. Radio buttons to choose between status, creator(author), priority and class
2. Dropdown menu that displays values depending on which radio button is pressed.
3. Gallery that is filtered based on what dropdown value user has selected.
To the dropdown menu I've just inputted manually the values. For author however there's no way I can add every person to the list and it is not convenient to update the values everytime employees change. So I thought I make dynamic values based on author of ticket (author name collected automatically when user creates the ticket). And here comes the problem: No matter what I do, I get empty values to the dropdown.
First I tried to add Distinct(SharepointList; Author) and Distinct(Sharepointlist; Author) on the dropdown Items field but best I could get was blank options. Next I created a new collection by using ClearCollect(colAuthorList; Author.DisplayName) on screens OnVisible field, then adding Distinct(colAuthorList; Result) on dropdown Items field. Results were the same, only blank options.
Does this problem has something to do with the Author field? It was a ready column in Sharepointlist that I just checked to be visible. I thought it would ease the use of the helpdesk app since user no longer have to manually add their name since Sharepointlist can automatically collect the users name during the creation of ticket.
Everything else seems work. Manually inputted dropdown values shows correctly but dynamically inputted values shows blanks. Only clue that I know I'm doing something right is that there as many blank values as there would be author names. Let say there's total of seven tickets but only three unique authors. I can get the dropdown to show three values even though they're all blanks.
EDIT: Okay tried to create dynamic values for other options too. The dropdown doesn't seem to be willing to show any values if I enter anything else than straight values on table (like ["option1";"option 2";"option 3"] etc).
