Announcements
My Dataverse table "Paises":
The dropdown:
Items: Paises
Default: LookUp(Paises, Codigo = 2)
The formula in the Default property returns the error:
Expected Text Value
Hi @WebPortal can you try this:
LookUp(Paises, Codigo = 2).Country
My example:
Items:
Default:
Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.
If the content was useful in other ways, please consider giving it Thumbs Up. 👍
Thanks
Andrew
@AndrewR1
That solves the error.
But it doesn't matter. The Default country is always the same - the first it finds.
That's because the LookUp always looks for the same value Codigo = 2.Since you use Dataverse, I tried to do the same on my end. Imported the "Pets" entity and then added the dropdown.Now, I simply had to choose the value for the dropdown in the properties bar
You could use the SortByColumns formula to sort it as you prefer.
Ok @WebPortal what did you want it to do then as you haven’t specified what your expectations are?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 977
Valantis 664
11manish 530
