Unanswered

excel database with formulas now gallery will not show

(0) Share

Report

Posted on by Matt383

407

Hi, I have a powerapp using excel as a datasource. Gallery was displaying fine until i put some =SumIfs formulas into some of the columns, the formulas calculate as the should, however the gallery will not show any data now. If i remove the columns with the formula, it works fine. I currently dont have any filters on the gallery. Excel datasource is called EngineSpecs_1

I have the Items of the Gallery1 set to EngineSpecs_1 and the Default is currently blank. There is no errors in the gallery and within the gallery, the labels are set to ThisItem.JobNumber, ThisItem.Customer, etc.

Any ideas on why this may be happening or who i could resolve it, cheers

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @Matt383 ,

Power Apps using Excel as a data source (a very bad one though) only uses the formatted table to access Text and numeric values - Power Apps cannot "see" calculated columns in Excel.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Matt383 407 on at

Like (1)

Report

Ok thanks, was only using the excel for the timesheet part, thought it might be easier to total up hrs for individuals and hrs to job allocation. So Sharepoint then? Last time i used sp, once i had 300-400 entries it was painfully slow to load when accessing from sharepoint list directly.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report

Hi @Matt383 ,

Yes SharePoint though I am not sure why 300-400 records would be slow to load.

Was this reply helpful? Yes No