I am new to Power Automate and i am stuck in one requirement.
I have a Macro Enabled Excel file with 3 tabs in it which is stored in Sharepoint folder.
So I need to create flow in which as soon data comes in excel file (tab 1-Raw Data) my macros run automatically through Power Automate And refresh my data in TEST-2 and TEST 3
Can anyone have any idea how to create such kind of flow?
Choose the trigger When a file is created or modified (properties only) from the SharePoint connector.
Configure it to monitor the folder where your Excel file is stored.
2. Download that excel file using SharePoint action as shown in below.
3. Go to Power Automate desktop
Add the Launch Excel action from the Desktop flows connector.
Configure it to open your macro-enabled Excel file.
4.Run the Macro:
Add the Run Excel macro action.Specify the name of the macro you want to run. Below image will give you an idea.
(Note:- if you got your solution you can mark as solution and gives kudos)
Thanks & Regards
Vishnu Reddy
Was this reply helpful?YesNo
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.
4
Share
Report
All responses (
Answers (
