Unanswered

Update Excel File using PowerBI dataset

(0) Share

Report

Posted on by PKPK90

Hi, what I am trying to do, is to create PowerApp that will take data from PowerBI Dashboard (OData as a source) and using PowerApp will create new records in Excel file which is not connected to PowerBI (shared on OneDrive).

Flow:

PowerBI -> PowerApp -> Columns included (Site, Order Number, Order Line, Comment) -> Filter Order Number -> Add Comment in PowerApp -> Send filtered (Site, Order Number, Order Line, with NewComment) into Excel file shared on OneDrive and create new rows

Is it possible? Thank you in advance.

*Normally I will use Lists or Tasks but we need to be sure that Order Number and Order Line is correct, that is why I need to take it directly from the system avoiding manual entry.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report

Hi @PKPK90

You mentioned you would use Sharepoint Lists for this but wanted to avoid manual entry. I would recommend YES! Use Sharepoint instead of Excel for this. You will not need to have anyone manually enter the Excel data into a Sharepoint List. Just use Power Automate to create the list based on your Excel:
This is super easy to set up and then you can use your List as the data source for your Power App. This will be much better in the long run as its a super pain to have Excel as your data source.

If this will work, please accept as a solution to close out this question. However, if you really need to use Excel please reply and I (or someone else) will try to help you out

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report

I just remembered this great article if you do want to export to Excel: https://www.matthewdevaney.com/power-apps-export-to-excel-as-a-csv-file/

Was this reply helpful? Yes No