cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ganser
New Member

If Excel has a formula, data not showing??

I've been trying to create a price list for all my products were I calculate payment methods , installments interests, etc. I would have liked when i modify my excel all the Team have a refreshed price list. The problem is that if my Excell has formulas the Table won't display any data. Is that right or am I missing something. I just realized that by replacing the formulas with plain numbers and the all showed up.

Is there anything I can do? I'll appreciate any tips, thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Hi

 

Yes. I wish PG can do something on this.

My very first experience: DATE Format. If it is entered from Excel, and loaded, and then use Date Format from PowerApps, everything will mess-up and the whole table will not be loaded.

Delete the affected Field (Column), add back, it will work.

So, loading raw data, and enter date from apps is more secured.

 

hpkeong

View solution in original post

8 REPLIES 8
hpkeong
Community Champion
Community Champion

Hi

 

Apps is loading RAW DATA (from Excel), and you execute program with syntax to calculate whatever you want and save it back to Excel in pre-defined fields / column.

I have posted before in forum that someone else also made the same mistake.

(Forget about all those formula when writing program here).

 

TQ

hpkeong
CarlosFigueira
Power Apps
Power Apps

Tables in excel with formulas are currently not supported. The app should be showing an error instead of silently ignoring them, this is a bug that we have in our side and we're working on a fix.

 

If you feel that the scenario of supporting excel tables with formulas is important, please create an issue in the PowerApps Ideas board (or vote up if it already exists). 

Hi

 

Yes. I wish PG can do something on this.

My very first experience: DATE Format. If it is entered from Excel, and loaded, and then use Date Format from PowerApps, everything will mess-up and the whole table will not be loaded.

Delete the affected Field (Column), add back, it will work.

So, loading raw data, and enter date from apps is more secured.

 

hpkeong

View solution in original post

mr-dang
Community Champion
Community Champion

If you need a solution, I have a conditional solution.

 

When I had this same problem as you, instead of adding my datasource as writeable data, I added it as static data. By chance, my table did not need to grow. If your table does not need to write new rows, this solution will work for you.

Microsoft Employee
@8bitclassroom
ppmp
Regular Visitor

2.5 years later and it still doesn't accept excel tables with formulas? I have a simple vlookup and that's enough for it to not work 😕

Best practices are that the backend tables of a database not contain calculated fields. The calculations are usually done on the front end.

and how to do that? "to add as statistic data" ?

Hi @herbertp 

There is an option to add data as "static".  Go to View-DataSources-New Connection and choose the first option. Capture.PNG

This only works if you are not going to add or change any data.  Otherwise, You can import the data numbers and do the calculations using PowerApps formulas. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,805)