cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ganser
Level: Power Up

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
hpkeong
Level 10

Re: If Excel has a formula, data not showing??

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
Level 10

Re: If Excel has a formula, data not showing??

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
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: If Excel has a formula, data not showing??

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). 

hpkeong
Level 10

Re: If Excel has a formula, data not showing??

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

Highlighted
mr-dang
Level 10

Re: If Excel has a formula, data not showing??

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
Level: Powered On

Re: If Excel has a formula, data not showing??

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 😕

Super User
Super User

Re: If Excel has a formula, data not showing??

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

herbertp
Level: Powered On

Re: If Excel has a formula, data not showing??

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

Super User
Super User

Re: If Excel has a formula, data not showing??

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,620)