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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,720)