Hi @Anonymous ,
Could you please share a bit more about the 'furniture' column in your SP list? Is it a Choice type column or a simple Text type column?
Is the Furniture a column in your TypeFurniture Table?
Based on the needs that you mentioned, I think it could be achieved in your app. I assume that the Furniture is a column in your TypeFurniture Table, please take a try with the following workaround:
Set the Items property of the Dropdown box inside your Gallery to following:
Distinct(TypeFurniture; Furniture)
Set the Default property of the Dropdown box to following:
a) If the furniture is a Choice type in your SP List:
ThisItem.furniture.Value
b) If the furniture is a simple Text type column in your SP List:
ThisItem.furniture
Please consider take a try with above solution, then check if the issue is solved.
If the Dropdown control could not work in your canvas app, please consider add a ComboBox control to list options from your Excel table instead of Dropdown control inside your Gallery.
Set the Items property of the ComboBox to following:
Distinct(TypeFurniture; Furniture)
Set the DefaultSelectedItems property of the ComboBox to following:
{
Result: ThisItem.furniture.Value // furniture is a Choice type column in your SP list
}
OR
{
Result: ThisItem.furniture // furniture is a Simple Text type column in your SP list
}
Please take a try with above solution, check if the issue is solved.
Best regards,
