Hi @Thom89
Please refer to the screenshot below. Using the expression below:
ClearCollect(DropdownCollection,Distinct(TabelaFormulário,'Primeira Página'),Distinct(["Germany","France"],Value));
Excel Table Name: TabelaFormulário
Excel column: 'Primeira Página'
To add values in dropdown other than the ones retrieved from the excel, you can create a collection and use the same collection in dropdown "items".
This collection can be created either on page visible or some control action.
Note: Please make sure that when you are creating collection, all the different arrays need to be filtered out as results using the Distinct Function(like I have used in my formula), otherwise it will store the values in different column.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
