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

Community site session details

Session Id : 1uTjvV6mtZ8SOHA44pR0Wg
Power Apps - Building Power Apps
Answered

Dataverse and sharepoint list

Like (0) ShareShare
ReportReport
Posted on 19 Dec 2023 12:03:21 by 2,245

Dataverse and SharePoint list functionality. When we build apps then when using SharePoint list we can fetch data using formula but in dataverse wether we have any limitations to display or fetching data. Kindly recommend since im using as400 and import in dataverse due to data authorization etc

  • BCLS776 Profile Picture
    8,988 Moderator on 20 Dec 2023 at 22:57:25
    Re: Dataverse and sharepoint list

    @Veblitz wrote:

    OK. I like to understand if lotus notes data needs to be Migrated using some tool or just convert to csv or excel. Reason is I have no idea about these datasources. Kindly shed some light about this lotus note data into sharepoint. I greatly appreciate your kind  technical guidance.  Thanks in advance


    Sorry, I don't know much about Lotus Notes to be able to help you with this

  • Veblitz Profile Picture
    2,245 on 20 Dec 2023 at 20:52:45
    Re: Dataverse and sharepoint list

    OK. I like to understand if lotus notes data needs to be Migrated using some tool or just convert to csv or excel. Reason is I have no idea about these datasources. Kindly shed some light about this lotus note data into sharepoint. I greatly appreciate your kind  technical guidance.  Thanks in advance

  • Verified answer
    BCLS776 Profile Picture
    8,988 Moderator on 19 Dec 2023 at 19:31:15
    Re: Dataverse and sharepoint list

    @Veblitz wrote:

    By transfer data from host as400 to excel and import to sharepoint list . Office365 environment is our target. So how open it's to everyone and in the context of authorization etc. Ideally,im trying to migrate with SharePoint with cost friendly


    Dataverse offers many more configuration options for security and privacy. You can restrict who has access to certain tables, records, or columns, unlike a SharePoint List that is open and available for an authorized user to see in its entirety.

  • Veblitz Profile Picture
    2,245 on 19 Dec 2023 at 15:09:33
    Re: Dataverse and sharepoint list

    By transfer data from host as400 to excel and import to sharepoint list . Office365 environment is our target. So how open it's to everyone and in the context of authorization etc. Ideally,im trying to migrate with SharePoint with cost friendly

  • Veblitz Profile Picture
    2,245 on 19 Dec 2023 at 15:05:32
    Re: Dataverse and sharepoint list

    Thanks for your great inputs.

    Yes dataverse got lots of benefits and your inputs helped me a lot in assessments. sharepoint list don't have any additional cost,but dataverse comes with license cost in one way,but mainly it's secured than sharepoint list.

     

    • Last but not least, s400 needs to be Migrated but looking to understand if there are anyway cost minimal or free storage other than sp lists
  • Verified answer
    BCLS776 Profile Picture
    8,988 Moderator on 19 Dec 2023 at 14:21:47
    Re: Dataverse and sharepoint list

    Dataverse is a relational database that gives you the ability to preserve relationships among records. As well, a Dataverse table can handle something like 30 million rows, so you can work with relatively large data sets.

     

    The biggest advantages over a SharePoint List are:

    • More delegable operations for easier in-app queries
    • Configurable Views for advanced filtering/sorting of data
    • The capability to use FetchXML for advanced querying of data, particularly through relationships

     

    From your other posts, I see you are still trying to get data out of an AS400 system, so that will be your primary hurdle. Dataverse offers additional ways beyond a CSV file to import data, which may help you out:

    BCLS776_0-1702995694715.png

    Hope that helps,

    Bryan

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete