Unanswered

Displaying Table Items from Choice Column

(0) Share

Report

Posted on by Zaneeee12

I have a Dataverse table, that has a column that is a Choice lookup.

I am using Powerapps to save data into the table ok. But now I want to display a Gallery with all the columns from specific rows. My number rows are showing ok, but my Choice Columns are not happy.

Code.

Refresh('Expenses');

ClearCollect(collectionOfItems, 
 Filter('Expenses', , 'Expenditure ID'.ID = varViewExpensesItem.ID)
);

Then when i put the above on a Gallery, and use the $ Amount column, its ok and gives me values, but when I select the Cost Center or Project Code column which is a Choice, I get the error:

Any ideas please

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like (0)

Report

Hello @Zaneeee12,

Using your code, you are currently referring to the record that is selected in your choice column.
If you want to display this record in your gallery in a control, you would have to specify the field from the Cost Center or Project Code tables that you are interested in. E.g: CostCenter.Name to display the value from the Name column in the CostCenter table.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Zaneeee12,

Do you want to filter the Gallery based on a Choice column from your Dataverse table?

Could you please tell me that the specific field type of the 'Project Code' and 'Cost Center', both are LookUp or Choice?

If they are choice, please modify your formula as below:

ThisItem.LookUpField.FieldFromAnotherTable // FieldFromAnotherTable is the field where the LookUp field retrieves value from

Note that 'The Food' is a LookUp column in my main table that I used to populate the Gallery, and to display the 'The Food' value, I refer to it as below:

ThisItem.'The Food'.'Food Name' // 'Food Name' is the field where the 'The Food' retrieves values from

Was this reply helpful? Yes No