A loosely coupled alternative is to have Excel send an email (like to a privated shared mailbox created for this purpose, for example). In the subject you can specify a key text (that gets filtered in PA to activate the flow, so it will only do it with certain emails) in the body of the email you can put all the data you want, in JSON format for example, and then have the PA flow activated when an email arrive to that specific mailbox with the specific subject, parse the JSON and voilá. We've used this many times to trigger PA flows (like from Typeform for example). One benefit is that it can be used offline without Internet (and when you get back online all the flows will be triggered). Another benefit is that you can track and debug the entire solution by simply opening the mailbox from a mail client. PA has a component to parse JSONs so, and Excel a VBA function to send emails, so it's all quite simple. Thank you for your video!
hi,how do you declare the user name in the URL so that take the excel user name who trigger the flow? i am just working on a shared excel sheet and wondering if user name can be variable depending on the user triggering the flow
I was trying to follow your tutorial, but when I click the link in the excel file it returns the following message: { "error": { "code": "DirectApiAuthorizationRequired", "message": "The OAuth authorization scheme is required. Please add authentication scheme and try again." } } I noticed also "When HTTP request is received" trigger has now additional field above "HTTP GET URL" asking who can trigger the flow. Do you know how this issue could be resolved?
UPDATE: I found the solution. This additional field "Who can trigger the flow" needs to be set to "Anyone". If this is set to "Any user in my tenant" or "Specific users in my tenant" it will require authentication.
Scripts are saved in a separate file, and can be run in any workbook. They do not trigger the warning message to enable macros. They are built with modern security in mind and therefore do not have the same risks as macros.
@@ExcelOffTheGrid Thanks a lot for sharing this, I actively looked for triggering power automate flow from excel solution and today RU-vid suggested your video for me! using Script (which i was not familiar with) seems to be the best option for me now.
Hi Sir, for the office script, I got error if click on run scripts or add button An unexpected error occurred. Close the task pane to try again. however click on the URL generated and paste in B2, and click directly got no issue what could be the possible cause ? Thank you !