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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to check the setti...
Power Apps
Unanswered

How to check the settings of Personal Productivity environment for importing table ?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

 

I am trying to import an excel file as a table in personal productivity environment. But I am getting the below error (screenshots for reference). Can anyone suggest how can we check the settings of importing table from ADMIN center ?

 

PA1.pngPA_ErrorMessage2.png

 

Thank you in advance

Categories:
I have the same question (0)
  • JayMagness Profile Picture
    1,663 on at

    HI,

    There are a lot of ways to do this process.

    1) in excel first of all make the data A table, then click in any cell and you can see table design, then Export then Select SharePoint. etc....

    2) I like to use Access to test all this because it connects easy. Import the excel spreadsheet into Access then export it from there to the SharePoint site. this is cleaner and easier in my view.

     

    in the end you may have rights issues, but I have seen this a few times with just different versions and program compatibility.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @JayMagness ,

     

    Thanks for providing insight. Here I am trying to understand why we do not have rights in the personals productivity environment even though we have facility to directly import the data from Excel file. Therefore, the question has been asked how to check the rights of Personal Productivity Environment

     

    ankibano_0-1690454633059.png 

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

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
WarrenBelz Profile Picture

WarrenBelz 427 Most Valuable Professional

#2
11manish Profile Picture

11manish 201 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard