[BUG]: FluentDetailsList not showing formula fields when using AddColumns to Dataverse datasource

microsoft / powercat-creator-kit

This toolkit helps create well-designed Power App experiences on the web & mobile. It contains a component library; PCF controls and other utilities that increase developer productivity.

MIT License

309 stars 51 forks source link

[BUG]: FluentDetailsList not showing formula fields when using AddColumns to Dataverse datasource #496

Open spgucken87 opened 6 days ago

spgucken87 commented 6 days ago

Describe the bug If using AddColumns in the Items property of a FluentDetailsList any formula columns in the Dataverse datasource will all be null/blank in the DetailsList.

To Reproduce Steps to reproduce the behavior:

Add formula fields to a FluentDetailsList
In the Items property utilize AddColumns function
Observe your formula fields show blank in the DetailsList

Expected behavior Expect that the formula fields show as they would without using the AddColumns function

Screenshots

Additional context Add any other context about the problem here.

MaheshSripada commented 4 days ago

Hi @spgucken87,

We appreciate you bringing this to our attention.

Unfortunately we are unable to reproduce this issue in our environment by using collection with AddColumns using Dataverse datasource. Tried in OnVisible, App.Start and App.Formulas and by changing the Power Apps studio version.

But I have faced this issue when I gave the incorrect / misspelt column name in the Columns property for the TagColorColumn where the color is not rendered correctly (as shown in above screenshot)

Please provide any additional details which might help us troubleshoot further.

spgucken87 commented 4 days ago

In my Datasource ideal_statuscolor is a formula column. If AddColumns is used, that formula column does not show any data. Your example above does query any formula columns.

MaheshSripada commented 1 day ago

Hi @spgucken87,

Pls use the color format in the rgb format for the color in the PowerFx formula. Example formula in below screenshot.

spgucken87 commented 1 day ago

I am unsure why you are stuck on the color. Any formula column does not show data on the details list if AddColumns is used. I was just using that color as an example, if I were to add ideal_statuscolor as a separate text column on the details list the same behavior happens.

MaheshSripada commented 1 day ago

Hi @spgucken87,

Sorry for the inconvenience caused. I have also used the AddColumns with Formula column which is displaying the data in the details list for the formula column.

Screenshot of Items & Columns property.