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
Super User
Super User

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
6 REPLIES 6
Super User
Super User

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

Super User
Super User

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
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 :/

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

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Tomorrow, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 120 members 3,764 guests
Please welcome our newest community members: