web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / simple excel can not c...
Power Apps
Answered

simple excel can not create powerapp says unexpected error while create powerapp

(0) ShareShare
ReportReport
Posted on by Migrated_User 2,129

Content migrated from TechNet.  Post attribution to: Amit Lohogaonkar sharepointer

 

I have below very simple excel file with one table-

I uploaded it my onedribe personal and used create from data. It shows up my table but after clicking on connect it shows

can not create powerapp says unexpected error . I am facing this for many excel sheet. Sample excel sheets on powerapps site work but not custom created ones by me. I need to know what am I missing.

 

 3345.png

  

MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

Categories:
Building Power Apps
  • Migrated_User Profile Picture
    Migrated_User 2,129 on at

     

    I also got "tables did not load correctly" for few excel sheets created using excel with templates like warehouseinventory etc. .

    MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

  • Migrated_User Profile Picture
    Migrated_User 2,129 on at

    hi can you share with me your sample excel through onedrive so that I can verify for you what went wrong.

     

    PK Hong

  • Migrated_User Profile Picture
    Migrated_User 2,129 on at

     

    yes I can, please share your onedrive ID. Thanks.

    MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

  • Migrated_User Profile Picture
    Migrated_User 2,129 on at

    you can also use excel to create new excel using out of box excel template using warehouse inventory excel template.

    MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

  • Migrated_User Profile Picture
    Migrated_User 2,129 on at

    Hi

    You just generate a LINK in your OneDrive (from Website OneDrive) and paste it here, them I should be able to download.

     

    PK Hong

  • Migrated_User Profile Picture
    Migrated_User 2,129 on at

    you can also use excel to create new excel using out of box excel template using warehouse inventory excel template.

    MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

     

     

    What do you mean? are you saying you got it done already? then that's OK.

    PK Hong

  • Migrated_User Profile Picture
    Migrated_User 2,129 on at

    try this one

     

    https://onedrive.live.com/redir?resid=A51BB7F3CFCF6EF4!91488&authkey=!AFn5GB8JV3y233I&ithint=file%2cxlsx

    DESCRIPTION BIN # LOCATION UNIT QTY REORDER QTY COST INVENTORY VALUE __PowerAppsId__
    Item 1 T345 Row 2, slot 1 Each 20 10 $30.00 $600.00  
    Item 2 T345 Row 2, slot 1 Each 30 15 $40.00 $1,200.00  
    Item 3 T5789 Row 1, slot 1 Each 10 5 $5.00 $50.00  
    Item 4 T9876 Row 3, slot 2 Box (10 ct) 40 10 $15.00 $600.00  
    Item 5 T098 Row 3, slot 1 Each 12 10 $26.00 $312.00  
    Item 6 T345 Row 2, slot 1 Each 7 10 $50.00 $350.00  
    Item 7 T349 Row 1, slot 2 Each 10 5 $10.00 $100.00  
    Item 8 T5789 Row 1, slot 1 Each 19 10 $3.00 $57.00  
    Item 9 T9875 Row 2, slot 2 Package (5 ct) 20 30 $14.00 $280.00  
    Item 10 T349 Row 1, slot 2 Each 15 8 $60.00 $900.00  
    Item 11 T349 Row 1, slot 2 Each 25 15 $8.00 $200.00  

     

     MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

  • Verified answer
    Migrated_User Profile Picture
    Migrated_User 2,129 on at

    Hi

    I have tested on DropBox, OneDrive.

    - Finally, I found that your data INCLUDES "formula". To prove that I was wrong, I loaded and results - FAILED.

    - I remove all your formula (Copy and Paste (V)), and still FAILED.

    - I copy the above data (without formula), and save into another New Excel File. DONE!

    I checked and convert into range and found that your tables are embedded with some strange duplicate headers.

    So, I can conclude that:

    1. Excel is used to store RAW DATA only for apps to load. Please REMOVE ALL THE FORMULA, and SAVE into another FRESH Excel.

    2. PowerApps has all the FORMULAS and FUNCTIONS (as of Excel and more user friendly; Done once solve forever) to manipulate all the data and Patch all your required calculation.

    Best wishes.

     

    PK Hong

  • Migrated_User Profile Picture
    Migrated_User 2,129 on at

    cool! thanks PK for find this!

    MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

  • Migrated_User Profile Picture
    Migrated_User 2,129 on at

    cool! thanks PK for find this!

    MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

     

    Not to mention! Thanks for sharing nice example and sharing coding.

    PK Hong

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans