Answered

Question about using Power Automate in Macro-enabled Excel file

(1) Share

Report

Posted on by cferv_77

Hello, I am new to Power Automate (PA) and would like to know if the following situation is possible.

On an Excel file, I have a form that has a macro that communicate with a SQL DB to auto-populate certain fields when given a Case ID#. Then the user manually fills out the rest of the form. Is it possible to have a ‘button’ when pressed, triggers a PA flow that takes a HTML copy of the form and then email it to a designated inbox?

If so, I would greatly appreciate some reference links to help me create this flow. Please let me know. Thank you.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

365-Assist 2,324 Moderator on at

Like (1)

Report

My recommendation is replace the Excel form with a Power App Form. Then you can easily communicate with your SQL DB.
If you still need the Excel file then you can have the Power App update or Read from Excel as well. You can also get the App to email.

--------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
cferv_77 71 on at

Like (1)

Report

@365-Assist
Thank you for your reply. In regards to the second option of having the PowerApp read the Excel file. So I am thinking after the user completes the form, click on the hyperlink to the PowerApp that reads the data and then email it. Would the Excel data connection within the PowerApp need to be refreshed manually or is it live?

Also, would I need a Premium account to use Excel Online (Business) connector?

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (1)

Report

The Power App connection is live update to the Table. Here is some links that can help show you how to do it.
Connect to Excel from Power Apps - Power Apps | Microsoft Docs
How to create Power Apps using Excel ? - YouTube
Note - You need to store the Excel in OneDrive or SharePoint.

No you don't need a premium license for Excel.

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No