Play Table Cells (Modern) Show / Production Table Cells Do not | Only specific cells

(0) Share

Report

Posted on by Jbeau83

Good Afternoon Community,

I have an odd issue going on that I cannot seem to get corrected and would appreciate your feedback:

I have a reference table used to pull down from a SPlist , data specific to the Value selected in a gallery.

Due to the list size (Current and Projected and indexed etc) , I am currently using a Lookup function see below:

Filter(ActionPlan, Title = LookUp(APlist, Title = Gallery.Selected.Title).Title, Status.Value in ["Pending", "On Track", "Delayed","New", "Complete"])

Which in play mode produces:

However in Production produces:

User permissions are present for the data set etc (As it pulls a status value) , The Table is set to

Displaymode.Edit

I'm lost on where to go from here, any feedback would be most appreciated.

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Jbeau83 47 on at

Like (1)

Report

Play Table Cells (Modern) Show / Production Table Cells Do not | Only specific cells

Good Morning Again,

@stampcoin | I essential rebuilt the entire table (modern) as a new asset and voila it started working. Literally no other changes, even using my original formulation (and again using your improved version). I ... I have no words. None, Except thank you for helping me work through this. I hope you have an amazing day!

-JB

Was this reply helpful? Yes No
stampcoin 4,082 Super User 2025 Season 2 on at

Like (0)

Report
Play Table Cells (Modern) Show / Production Table Cells Do not | Only specific cells

@Jbeau83 Hi,

That's odd...

I found one similar thread:

https://www.reddit.com/r/PowerApps/comments/1dcfe3p/comment/l7zulrq/

"I had the same problem with several SharePoint list from the same site, 5 worked OK and the 6 one didn't show any data. If I deleted the Gallery and put a data table it showed data but then I put gallery and show nothing, if I go to monitor it says my list is empty. The way I fixed it was reloading the datasource in same screen where the Gallery was. This gallery that I was talking about was one where I first pick a item and then show another gallery from another source filtered by previous selected item in last gallery. It was my main gallery too. Edit: I could see the data in preview but not in published."

Another one is use a separated screen only for yourself, add the table only, use static values for your filter.

Filter( ActionPlan, Title = "StaticTitle" // see if it can load data in UI )

If you tried everything ( hope you have a check list, include publish).

Take a break ( if not urgent), review your check list when you feel relax.

if no clue, give the support a ticket.

Was this reply helpful? Yes No
Jbeau83 47 on at

Like (0)

Report

Play Table Cells (Modern) Show / Production Table Cells Do not | Only specific cells

@stampcoin,

Still no change. Again, Thank you for the insight. It is frustrating to say the least why this is a visual bug and not an actual data issue. Even in Monitor , nothing is flagging. I may try to change back to the old table controls to see if another outcome is possible as well. I still welcome additional feedback and insight; as this issue really is a head scratcher. I may have to escalate this to Microsoft directly.

Thank you again,

-JB

Was this reply helpful? Yes No
stampcoin 4,082 Super User 2025 Season 2 on at

Like (0)

Report

Play Table Cells (Modern) Show / Production Table Cells Do not | Only specific cells

@Jbeau83 Hi,

Thanks for the feedback.

The data is definitely loaded as you saw it in play mode, but not when you actually use it.

I think it worth to try add refresh() the data when the screen visible.

Was this reply helpful? Yes No
Jbeau83 47 on at

Like (0)

Report

Play Table Cells (Modern) Show / Production Table Cells Do not | Only specific cells

@stampcoin,

Thank you for your continued support on this:

I am able to pull down a full and "clean" collection, My row view is set to 2000k, I am testing on a "fresh" browser even. Still same issue with only Status appearing in production, but all cells appearing in Play mode.

I am scratching my head on this one.

Was this reply helpful? Yes No
stampcoin 4,082 Super User 2025 Season 2 on at

Like (0)

Report

Play Table Cells (Modern) Show / Production Table Cells Do not | Only specific cells

@Jbeau83 Hi,

Could you please try below actions ?

1. Settings > General > Data row limit: 2000, and test it.

2. Use ClearCollect to collect the result if you can get full records, to exclude if any problem of the modern table.

3. Use live monitor if you can find anything strange.

4. Reload everything to make sure nothing cached.

Was this reply helpful? Yes No
Jbeau83 47 on at

Like (0)

Report

Play Table Cells (Modern) Show / Production Table Cells Do not | Only specific cells

@stampcoin,

Thank you for the re-write (It is a much cleaner pull), however visually no change. The Status field is field with the others empty.

Was this reply helpful? Yes No
Verified answer

stampcoin 4,082 Super User 2025 Season 2 on at

Like (0)

Report
Play Table Cells (Modern) Show / Production Table Cells Do not | Only specific cells

@Jbeau83 Hi,

I think the in operator could be the delegation problem.

With( { MyTitle: Gallery.Selected.Title }, Filter( ActionPlan, Title = MyTitle && ( Status.Value = "Pending" || Status.Value = "On Track" || Status.Value = "Delayed" || Status.Value = "New" || Status.Value = "Complete" ) ) )

Was this reply helpful? Yes No

Community site session details

Play Table Cells (Modern) Show / Production Table Cells Do not | Only specific cells

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates

Community site session details

Play Table Cells (Modern) Show / Production Table Cells Do not | Only specific cells

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Leaderboard > Power Apps

Featured topics

Product updates