cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ccancino
Level: Powered On

Data Table not displaying data

It was working just fine about 2 days ago but now my data tables do not display anything. I have a home screen that has a gallery then based on that gallery id I filter my data table on the next screen. I've tried everything but no luck.

 

Any Ideas? Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
ccancino
Level: Powered On

Re: Data Table not displaying data

Figured it out! For some reason my function/syntax stopped working as it was working fine before. So to get it to display I used the following:

 

SortByColumns(Filter('[dbo].[power_deal_vendor]', Text(deal_id) = DataCardValue5_1.Text), "id", Descending)

 

 

Instead of converting the right hand side with Value(DataCardValue5_1.Text) I did it on the left side instead even though it gives me a warning sign.

View solution in original post

9 REPLIES 9
DanielaH
Level 8

Re: Data Table not displaying data

Hello,

Have you tried simply removing the data table and re-adding it?

Otherwise providing a screenshot and the function/syntax you use might help resolve this for you.

ccancino
Level: Powered On

Re: Data Table not displaying data

I've attached an image of what my table looks like, empty and here is  my function/syntax:

 

SortByColumns(Filter('[dbo].[power_deal_vendor]', deal_id = Value(DataCardValue5_1.Text)), "id", Descending)

ccancino
Level: Powered On

Re: Data Table not displaying data

I've tried re-adding the table as suggested but nothing and also it displays data on the edit environment but not once published.

Eickhel
Level 8

Re: Data Table not displaying data

Hey,

 

Have you tried testing if you're getting data without filtering just to check if you're receiving any data at all?

ccancino
Level: Powered On

Re: Data Table not displaying data

Did not try this but when not filtering just regular o data source it works.

ccancino
Level: Powered On

Re: Data Table not displaying data

Figured it out! For some reason my function/syntax stopped working as it was working fine before. So to get it to display I used the following:

 

SortByColumns(Filter('[dbo].[power_deal_vendor]', Text(deal_id) = DataCardValue5_1.Text), "id", Descending)

 

 

Instead of converting the right hand side with Value(DataCardValue5_1.Text) I did it on the left side instead even though it gives me a warning sign.

View solution in original post

Eickhel
Level 8

Re: Data Table not displaying data

Hi,

I guess you are getting the warning because of the delegation. You are issuing a function on the data source itself, this could led you to bad performance later on.

 

Is the "DataCardValue5_1.Text" a number? try to fix it on the PowerApps side to avoid issues along the way.

ccancino
Level: Powered On

Re: Data Table not displaying data

Yes, it is a number and yes I got the warning sign but its the only way I could make it work. It wont display doing it the correct way which was:

 

id = Value(DataCardValue.Text)

 

which was working but suddenly stopped working and I do not know why.

Eickhel
Level 8

Re: Data Table not displaying data

It should work that way but it might be a conversion issue.

 

Have you tried veryfing the result of Value(DataCardValue.Text) in a variable?

UpdateContext({test:Value(DataCardValue.Text)}) 

 

And then check the variable though View / Variables.

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 311 members 6,152 guests
Please welcome our newest community members: