How to display SharePoint List items in Power Pages ?

(1) Share

Report

Posted on by JoshuaZaveri

Hello,

I have a SharePoint List and I want to display it in Power Pages directly. Any solutions ?

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

Hi @JoshuaZaveri

Yes, it is possible. In core, Power Pages require dataverse table to display the items.

The easiest way I can think of is to use the dataflow.

1. Go to https://make.powerapps.com/

2. Choose the right environment

3. Left menu > Dataverse > Dataflows > New Data flow

4. Name it "SPtoDV"

5. Choose SharePoint as the data source

6. Choose the existing table from the list

7. Transform (manipulate if required)

8. Then under the mapping part. Please choose a new table or load it into the existing table according to your need.

Note: you can make your dataflow as scheduled so that whenever the SharePoint list is updated, your dataverse table will automatically update.

Have fun.

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
JoshuaZaveri 4 on at

Like (0)

Report

Although I appreciate your answer. But, this is not what I was looking for. There is no Dataverse Table, that's why I asked if its possible to show SharePoint list items to the Power Pages directly.

Was this reply helpful? Yes No
saveri 138 on at

Like (1)

Report

Was this reply helpful? Yes No
saveri 138 on at

Like (1)

Report

Was this reply helpful? Yes No
saveri 138 on at

Like (1)

Report

Hii
Joshuazaveri
please go through this link it may be help
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-sharepoint-online

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

@JoshuaZaveri

What do you mean by no dataverse table? My screenshot tells you how to load into the new table. Power Pages is connected with Dataverse. Using dataflow you can achieve this.

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
DiegoSousa 2 on at

Like (0)

Report

Hello,

Thank you for the explanation, I had a similar issue and managed part of it! However I wonder if the changes I make in my dataverse table will be reflected in the SharePoint site. I have created a new table just like you showed, but the items I add in Power Portals don't appear in my SharePoint list.

Was this reply helpful? Yes No