Retrieving data and some dates are empty and displays errors?

(0) Share

Report

Posted on by fiddlerx

103

Hi team,

I have created a canvas app that has a gallery displaying data from an excel file.

When switching between weeks of the gallery I receive the following error message. Im not sure what text I have or what other data its trying to fetch when getting this message.

First I thought it could be related to the Weekday I was trying to display but I removed that part and re-rean the app a few times and its still there. I cannot understand this.. is there any tips of debugging such error message?

We have a column i the excel file with the date format of 2023-05-26 for example and some of those rows are empty sometimes...but cannot find what piece in the gallery that is requesting that...

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Aaron_Morva 38 on at

Like
a
(2)

Report
Copy link

Link copied!

Hey @fiddlerx,

maybe this answer from @Nogueira1306 could be helpful for you.

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @fiddlerx

if you want look more into error details you can use Monitor feature of Powerapp. it will provide you what exactly happening clearly

if you can show sample data and what formula you are getting error in gallery probably, we could help more.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
fiddlerx 103 on at

Like
a
(0)

Report
Copy link

Link copied!

Got a bit more information now bu still cannot find what it is that causes this.
Could it be related to when just collecting the whole Table1 data some dates are not correctly formated since I cannot find any thing in my tiny app that requests data from this column...

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @fiddlerx

This issue is most likely caused because you are using an Excel data source. Excel has a not-so-good reputation when it comes to providing data to power apps, a more detailed version here: https://www.youtube.com/watch?v=RtmZM3tm2Zs

Example:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Date-amp-Time-from-excel-data-source-not-showing-gallery/td-p/948242

Nevertheless, can you try re-adding your data source as that might be a quick fix for this issue? Just remove that table then add i again as one issue with excel is that when you make structure changes to the data source, it doesn't update that structure in power apps automatically. Have to re-add it.

Was this reply helpful? Yes No