Hi @ossidabossi!
That's the expected outcome . It`s the selected choice(s) for each row. It corresponds with what you see in your Sharepoint list. To narrow it further down, and get all individual choices to use as source for a dropdown, try this onStart of App or onVisbile of Screen:
ClearCollect(
colChoices,
{
Choice: Distinct(
'Louna...',
Concat(
Ruokalaji,
Value,
", "
)
)
}.Choice
);
Set(
varChoices,
Concat(
colChoices,
Value,
","
)
);
Set(
tblChoices,
Distinct(
Split(
varChoices,
","
),Value)
)
Then use tblChoices as datasource for the actual choices made. Hope, this is it 🤞
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
