Hello @LINK
I'm facing an issue with my app where I want to display the Category Name instead of the Category Key when adding a new expense record in a form. Here's what I have tried so far:
Setup:
Issue:
What Iโve Tried:
Expected Behavior:
Question: How can I ensure that the Category Name is displayed instead of the Category Key when entering a new expense? Is there a specific setting or approach I'm missing?
Any help or suggestions would be greatly appreciated!
Thank you!
@cgosilva wrote:
I want the Category Name (e.g., "Travel" or "Office Supplies") to be shown in both the form and in the data source instead of the Category Key (which is usually an ID).
Change the type of the Category column in the Expenses table to Text and set the column's Valid if expression to something like this:
SORT(
Expense Categories[Category Name]
+ LIST([_THISROW_BEFORE].[Category])
- LIST("")
)
It seems you want the category label and key to be the same.
In the "Expense Categories" table set the column [Category Name] to be they key and the label.
This will ensure the [Category Name] "(e.g., "Travel" or "Office Supplies") to be shown in both the form and in the data source"
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |