Unanswered

Behavior with Data Table selected fill

(1) Share

Report

Posted on by akharns

433

I have a screen with 3 data tables. The selected row in the top data table serves as a filter for the other two. I changed the Selected Fill property for the top data table to show it more clearly. I did not change the property for the other two data tables.

I am getting strange behavior for all three tables at runtime. My chosen selected fill color will sometimes stop showing in the top table and it will sometimes show in rows in the other tables. It seems to go off and on without any aparent trigger.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @akharns ,

Do you mean the Selected Fill property of the Top Data Table does not work, but work in other two Data Tables which have not set the Selected Fill property?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please consider do not filter your two other Data Table records based on the Top Data Table directly, instead, store the selected item in your Top Data Table into a variable, then filter your other two Data Tables based on the variable.

Please make sure you have removed the formula within the HoverFill property of the Top Data Table.

Please set the OnSelect property of All columns in your Top Data Table to following:

Set(CurrentSelected, DataTable1.Selected)

and remove the formula within the HoverFill property of the Top Data Table.

Then set the Items property of your other two Data Tables to following:

Filter('DataSource', FilteredColumn = CurrentSelected.ColumnName)

If the issue still exists, please consider turn off the "Enable improved data table control selection and Value property" option within Advanced settings of App settings of your app, then add new Data Table controls in your app, check if the issue is solved.

Note: Please make sure you do not change the Selected Fill property of the other two data tables.

Best regards,

Was this reply helpful? Yes No
akharns 433 on at

Like
a
(0)

Report
Copy link

Link copied!

This sounds very promising. I'll try it out. I still don't understand why a setting in one Data Table could impact a different Data Table.

Funny you should mention selected fill. I set the Fill property and suddenly started getting errors on selected fill or hover fill, that I could not fix. 😕

Was this reply helpful? Yes No
akharns 433 on at

Like
a
(0)

Report
Copy link

Link copied!

m getting all those fill properties mixed up. I'll have to check on whether it was selected fill or hover fill. Your suggestion that it might be a control-level property vs a column property might be the key. I'll look.

Was this reply helpful? Yes No
akharns 433 on at

Like
a
(0)

Report
Copy link

Link copied!

The Data Table doesn't have on OnSelect property, such that I could use it to capture the row into a variable. That's available only at the column, which doesn't make sense to me. A user selects a row, not a column.

Was this reply helpful? Yes No
akharns 433 on at

Like
a
(0)

Report
Copy link

Link copied!
More precise info:
My primary table has the selected fill set to RGBA(250, 155, 112, 1). I did not change the hover color or fill.
My secondary table has original selected and hover fills.
On the primary table, clicking a row once and moving away returns the fill color to pre-select values, acting as a hover fill. Clicking it twice causes it to stay with the new fill color.
On the secondary table, hovering over the table after getting the parent table to show new selected fill color causes the secondary table's 1st row to show with the new fill color. It stays after the mouse moves off the row. Clicking on any other row restores to the default fill color.
Very strange.

Was this reply helpful? Yes No
akharns 433 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried most of your recommendations. (The last one seemed more radical and I didn't know how to do it anyway.) I don't think it has changed much if anything. I did not try the last suggesting. It seemed radical and I didn't find the options you suggested.
As you have observed, the behavior is a mixture of "selected" and "hover" behavior. The details I provided in my last post are better. Clicking twice on a row behaves differently than clicking once, both for the top table and subsequent behavior in the lower tables.
I did create a variable with the key value rather than referencing the top table in the filter commands. I can't tell if it changed the behavior. Maybe not.
I actually don't want any selection in the lower tables, and I tried removing the selected fill from those tables. (I realize you said not to do that. I read that too late.) Regardless, the default selected fill still persists. This is not a serious problem, only a curiosity.
I think I need to ignore the quirky behavior. This app was intended as a utility rather than a primary business tool. I will need to think carefully about using multiple data tables on the same screen in the future.

Was this reply helpful? Yes No
dw909 49 on at

Like
a
(0)

Report
Copy link

Link copied!

So 3 years on and I've just encountered the same problem. How can this bug not have been fixed in all this time? I have my data tables in containers so I might try and make the tables and selections entirely transparent and rely on the underlying fill colour of my container, since in my case I don't actually want hover and select colours. Unfortunately I have tables of two different background colours in the same screen.

Was this reply helpful? Yes No