You’re offline. This is a read only version of the page.
395
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
Hi @Matt383 ,
Yes SharePoint though I am not sure why 300-400 records would be slow to load.
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.
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
Share
Report
All responses (
Answers (
