cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Migrated_User
Solution Sage
Solution Sage

PowerApps - "Error adding datasource. Please try again later." - (SharePoint Online)

Content migrated from TechNet.  Post attribution to:  Justin Nash

 

Is there list of SharePoint columns that are not supported if so where can I find it. I have a SharePoint Online list with the following column types:

  • Calculated (calculation based on other columns)
  • Choice
  • Date and Time
  • Lookup
  • Managed Metadata
  • Multiple lines of text
  • Number
  • Person or Group
  • Single line of text

When I go to connect to the list I get the following error: "Error adding datasource. Please try again later.".

I would have been happy had the supported columns come in to PowerApps and the invalid or unsupported columns got striped out possibly with at warning. But as it is I can't retrieve any data from my list. This is likely to be a real world case as I am just working with an existing SharePoint Online list that my company uses.

5 REPLIES 5
Migrated_User
Solution Sage
Solution Sage

Hi Justin,

Per my test, sounds the unsupported column type is "Managed Metadata" column. Would you please remove or change the metadata column type and test it again?

Unfortunately, there is no article about this at this time. I suggest you submit your feedback here: https://powerapps.uservoice.com/forums/331617-generalIt

Thanks,
Reken Liu

jaroreken
New Member

I have the same error when trying to connect to a list. I'm using these data types for columns:

  • Person or Group
  • Single line of text
  • Date and Time
  • Number
  • Calculated (calculation based on other columns)
  • Lookup
  • Yes/No

 Do you know if the error is because a column datatype or there are other known errors when getting data from SharePoint list?

I was able to import a simple list with two single line of text data type columns, though.

Joel
Regular Visitor

I had the same error.  I had programattically created an excel table to populate my powerapp.  I had programattically made the table name two words "Contact List"  When I changed it to "ContactList" It worked.

mr-dang
Community Champion
Community Champion

The last time this happened to me, the problem would not go away. I had to do something or I would be consistently unable to add sources.

 

So I went with the nuclear option and it worked: uninstall PowerApps and reinstall it from the Store. Worked like a charm. I have not had to do it since then.

Microsoft Employee
@8bitclassroom

Keep your PowerApps upgrading to the latest version is a good idea for troubleshooting.

According to the latest announcement, complex column types like Person or Group, Managed Metadata, Lookup, and Multi-select Choice are still not fully supported.

https://powerapps.microsoft.com/en-us/blog/powerapps-and-sharepoint/

 

Thanks,

Reken Liu

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 (2,150)