Is it possible to trigger an Office Scripts function within Excel Online as a result of a user action? For example, can I run a specific Office Scripts function when the user clicks on a hyperlink within Excel Online? If so, can you give an example of the syntax/setup of the hyperlink?
Asked
Active
Viewed 1,203 times
2 Answers
4
It is not possible to trigger based on user-action; we are investigating allowing trigger through a shape/image (button). Would that be something that'll meet your requirement? (I work on the product team)
Sudhi Ramamurthy
- 2,358
- 1
- 10
- 14
-
Yes, that would be great! – Engine Room Jan 13 '21 at 01:36
-
That is something I have been wanting ever since Office Scripts was introduced! Thanks for the update Sudhi! – Ethan Jan 14 '21 at 16:17
-
Happy to follow-up for more details. Please email at suramam (at) mirosoft . com for further questions. – Sudhi Ramamurthy Jan 19 '21 at 03:13
-
Nope. C'mon guys, Office Scripts is Javascript. Javascript supports on-page events. I realize it might be *difficult* for you... – johny why Apr 13 '21 at 14:07
0
You could try building a Flow (aka "a Power Automate") that is triggered on the "File Change event"(for the Excel file) in SharePoint. Instead of just having the Flow trigger on double-click you would need to enter data into the cell. Because the worksheet and, this, file changed the Flow would trigger. Good luck.
Les Black
- 51
- 2