Data Table not displaying data

[ccancino]

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!

[Anonymous]

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]

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]

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]

Hey,

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

[ccancino]

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

[ccancino · Accepted solution]

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.

[Eickhel]

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]

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]

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.