CODEWITHSUNDEEP
excel-onlineoffice-scripts
Engine Room
Engine Room

Reputation: 63

Call Function via User Interaction with Office Scripts in Excel Online

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?

Upvotes: 1

Views: 1864

Answers (2)

Les Black
Les Black

Reputation: 51

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.

Upvotes: 0

Sudhi Ramamurthy
Sudhi Ramamurthy

Reputation: 2478

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)

Upvotes: 4

Related Questions