Announcements
In Sharepoint, make sure the Default view has all the relevant columns.
In the Powerapps screen, select Import.
From the list choose Import data with DataFlows
Select Sharepoint online list
Enter the site URL.
Leave the implementation as 2.0
Select View mode as Default view
Enter Sharepoint credentials if prompted.
Click next on the bottom right.
Select tables to import
Click next
Select Load settings and import into a new table.
Check column mappings are OK.
Click Next
Select Refresh manually
Select Publish Now
Goto https://make.powerapps.com/dataintegration
Select DataFlows
Find the Flow you just ran
Click on the 3 dots
Press Refresh
Select the table
Why is the CreatedBy field in Sharepoint showing as list when importing to Dataverse?
The error happens because the Created By column in SharePoint is a complex People field, so Power Query sees it as a List/Record, not plain text. When the dataflow tries to load it into Dataverse as Text, you get “We cannot convert a value of type List to type Text”.
In the dataflow, either remove the Created By column, or click the expand icon next to it and choose a single field (e.g. CreatedBy.DisplayName or Email) and map that to a Text column in Dataverse. After adjusting the column type/mapping, refresh the dataflow again.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
