Create Sharepoint List from Power BI

(0) Share

Report

Posted on by rezafabric

Hi Folks

This is my first topic. Apologies for taking your time.

I need to create SharePoint list from Power BI data with the following considerations:

1- Not all the data need to be created in MS List, only the rows that user define need to be created in SharePoint List.

I assume to achieve this step, power app required. Creating a form to get the input IDs and submit the form.

2- Avoid item duplications and enable item updates for existing items.

3- The SharePoint list has been create with the same columns as Power BI table.

So basically is it possible to use the following apps? Could you please explain how to achieve this scenario?

Power BI > Power App (get the input IDs) -> Power Automate > SharePoint List

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @rezafabric

No worries at all we are all here to help each other.

Please can you clarify something for me. Where is the current data ? In a sql database, a csv file ?

Was this reply helpful? Yes No
rezafabric 8 on at

Like (0)

Report
Copy link

Link copied!

Hi Alaa

thanks for your reply. The data is in Power BI table.

Was this reply helpful? Yes No
rezafabric 8 on at

Like (0)

Report
Copy link

Link copied!

Let’s say there are 500 rows in the power bi table but only 5 rows need to be created in SharePoint list.

Was this reply helpful? Yes No
rezafabric 8 on at

Like (0)

Report
Copy link

Link copied!

I can have the data source in csv as well.

Was this reply helpful? Yes No
alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @rezafabric

Allright so if you just want to move some items to a sharepoint list you go even not use a power app and just create a power automate that will move your items directly to your sharepoint list. Or you want to let the user choose witch items will be moved ?

Was this reply helpful? Yes No
rezafabric 8 on at

Like (0)

Report
Copy link

Link copied!

I want to let them to input the desired ID/s.

Was this reply helpful? Yes No
alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @rezafabric

Allright so you need a power apps to display your items in a gallery. You add a check box and a submit button.

In the onselect property of your button you called a power apps triggered power automate that loops over all the id sent by the power app. If item id exist in the sp list then update the element or do nothing, if the item id does not exists then create the item in the sharepoint list.

Was this reply helpful? Yes No