Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Convert Excel VBA to Power Apps?

(0) ShareShare
ReportReport
Posted on by 25

Hi,

I have some Excel with VBA that is used to generate data report. 

Source data (csv files) will be pasted in specific path in my laptop daily like C:\Users\Desktop\Document. 

I will edit VBA when report logic needs to update. 

 

I hope I can use PowerApps to generate data report without editing any VBA. 

Is it possible to do so?  

 

Thanks,

 

  • SpencerCai Profile Picture
    SpencerCai 25 on at
    Re: Convert Excel VBA to Power Apps?

    Hi G,

     Your understanding is correct. 

    The second idea you mention: you can use PowerAutomate to read the data and store in a SP list and use PowerApps to create your gallery or logical grouping of data

    If I need to add a new calculation or change data source from a file to b file,  is it possible to do like you mention?

    I wish I can build an app, then I can change the data source or logic by click some checkbox.

     

    Many thanks,

  • g1224 Profile Picture
    g1224 348 on at
    Re: Convert Excel VBA to Power Apps?

    Based on my understanding of your query , I assume you want to execute some scripts to read a set of files stored in your drive and do some logics to derive a report from the data read . You can either use PowerBI with excel as data source to generate the report . Or if its basic reporting and you want to create a dashboard of the data read , you can use PowerAutomate to read the data and store in a SP list and use PowerApps to create your gallery or logical grouping of data . 

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard