Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : 46XVb4C4W7HByzkRD+pE8R
Power Platform Community / Forums / Power Up Program - Power Up Final Challenge / Unable to upload data ...
Power Up Program - Power Up Final Challenge
Answered

Unable to upload data to created tables

Like (2) ShareShare
ReportReport
Posted on 5 Apr 2025 20:56:03 by CU05042035-0 11
Hi community, 
 
I've tried all the ways i could but I'm absolutly unable to upload the data from the excel files to the tables for my animal shelter solution.  
 
Can it be a credentials issue or is it that i'm doing something wrong?
 
Thanks in advance for your support. 
 
Categories:
General Discussion
  • ronaldwalcott Profile Picture
    ronaldwalcott 3,495 on 18 Apr 2025 at 06:22:57
    Unable to upload data to created tables
    Is this still a problem?
  • Verified answer
    Zdenka_Cech Profile Picture
    Zdenka_Cech 64 on 17 Apr 2025 at 16:14:44
    Unable to upload data to created tables
    Hi 
    I had similar issue. Here are the steps:
    1. create all three tables structure - columns
    2. create model driven app with all three pages - tables
    3. save and publish all customizations
    4. Play the model-driven app 
    5. In model-driven app import from csv (upper right corner) in order 1st shelter, foster family, animal
    when you upload from model-driven you can map and add choices too.
    Do not import from solution.
    *Zdenka
  • w.p Profile Picture
    w.p 3,446 on 17 Apr 2025 at 05:18:25
    Unable to upload data to created tables
     
    Just following up on this, if you have any more queries.
    For housekeeping, please mark the post as answered, if you have no more queries.
  • Verified answer
    w.p Profile Picture
    w.p 3,446 on 07 Apr 2025 at 05:24:58
    Unable to upload data to created tables
     
    I'd recommend following these steps for the challenge:
    1-create shelter table, columns, view, and form (parent table)
    2-create foster family table, columns, view, and form (parent & child table)
    3-create animal table, columns, view, and form (child table)
    4-create a model driven app
    5-import shelter data via model-driven app using Export to Excel > Open in Excel Online > copy & paste
    6-import foster family data via model-driven app using Export to Excel > Open in Excel Online > copy & paste
    7-import animal data via model-driven app using Export to Excel > Open in Excel Online > copy & paste
    8-create a BI report to better understand the next steps, particular table relationships.
    9-create canvas app
    10-create Power Automate

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

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,626 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,962 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans