Datatable column with formula not getting refreshed

(0) Share

Report

Posted on by OmegaPhi115

Hi,

I got a strange case where power apps doesn't want to refresh my column.

For context, I got a datatable that is displaying some columns from a dataverse table.

The dataverse table got 2 fields (There's more, but they aren't relevant):

- "Statut Document" of type Choice (Statut Facture)

- "Display Status" of type Yes/No.

On powerapps's side, I got a column to display "Status Document". If "Display Status" is true, then it should return the value of the column "Status Document", if not, it should return a preset value of the "Statut Facture" choice

So I put this formula in the Text property:

If(ThisItem.'Display Status', ThisItem.'Statut Document', 'Status Facture'.Envoyé)

The only problem is that when "Display Status" or "Status Document" change in dataverse, it doesn't reflect the changes, even when using Refresh() on the table, while other columns do update normally

The following formula does update:

If(ThisItem.'Display Status', "Yes", "No")

Any help on this? Feel free to request for more info

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @OmegaPhi115 ,

I suspect that it's caused by the different data types between ThisItem.'Statut Document' and 'Status Facture'.Envoyé in this If statement. So, please try below instead:

Switch( ThisItem.'Display Status', true, ThisItem.'Statut Document', false, 'Status Facture'.Envoyé )

Best regards,

Was this reply helpful? Yes No
OmegaPhi115 31 on at

Like
a
(0)

Report
Copy link

Link copied!

That could be it, but it doesn't want me to use a boolean as a switch case: "Invalid argument type (Boolean). Expecting a OptionSetValue value instead".
Is there a way to convert ThisItem.'Display Status' to an actual boolean? Boolean(ThisItem.'Display Status') doesn't work

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @OmegaPhi115

I know the problem now. I have missed it's a Y/N column. Try below formula:

If( ThisItem.'Display Status'='Display Status'(TableName).Yes, ThisItem.'Statut Document'.Value, 'Status Facture'.Envoyé )

You can learn more details about Y/N column of Dataverse:

How to work with Yes/No columns in Dataverse | Hardit Bhatia: The Power Addict

Best regards,

Was this reply helpful? Yes No
OmegaPhi115 31 on at

Like
a
(0)

Report
Copy link

Link copied!

ThisItem.'Statut Document'.Value isn't recognized. But even if I remove the .Value, still no updating. Even if I use a switch.
Replacing the displayed value by "Yes" and "No" shows that it also doesn't update upon change of 'Display Status'.

One thing that might be relevant, is that it's possible for both 'Statut Document' and 'Display Status' to get changed after refreshing.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @OmegaPhi115 ,

Could you please provide a screenshot that shows related UI controls, so I can understand the scenario more clearly?

Best regards,

Was this reply helpful? Yes No
OmegaPhi115 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Here's the UI
The table is based on the Dataverse table "Factures", which is the table that contain "Statut Document" and "Display Status", and filtered on the user's ID stored in a global variable.

The reload icon got onSelect set to "Refresh(Factures);" to refresh the table
"Deconnection" and "Ajouter une facture" are navigation buttons and are only used to navigate to other screens

The "Statut Document" column is the one that doesn't change when updated. Its Text property is the formula that we are discussing

Was this reply helpful? Yes No