Forum Discussion

JasonYeung's avatar
JasonYeung
Brass Contributor
Apr 23, 2025

Creating a page which displays data from API or database

Hi,

I want to check whether it's possible to create a page in SharePoint that can display data from a dataset? (e.g. data from API calls or a SQL database). These can be done with regular websites, but I'm not sure if this can be done from within SharePoint.

Sincerely,

Jason

 

SharePoint Online

2 Replies

  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Apr 23, 2025

    Further to the answer by ArefHalmstrand, you could build an app in Microsoft Power Apps with SQL or Dataverse as the datasource and then use the Power Apps web part to embed the app in your SharePoint page.

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User
    Global Power Platform Lead WSP (and classic 1967 Morris Traveller driver)

  • ArefHalmstrand's avatar
    ArefHalmstrand
    MCT
    Apr 23, 2025

    Hello Jason,

    Pages in SharePoint use something called web parts. These webparts can show data from a SharePoint List or document library for example. It is possible to retrieve information that exists in SharePoint. However, if you would like to make an API call to fetch data from another source, then you would need some development skills to build your own webpart.

    Best regards,
    Aref Halmstrand

    Please mark as resolved if this was helpful 🙂

Resources