Is there any way to bind to onChanged events of a Escel Online file?

%3CLINGO-SUB%20id%3D%22lingo-sub-1432999%22%20slang%3D%22en-US%22%3EIs%20there%20any%20way%20to%20bind%20to%20onChanged%20events%20of%20a%20Escel%20Online%20file%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1432999%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20using%20Excel%20Online%20Connector%20alongside%20a%20PowerApps%20Canvas%20App%20and%20got%20a%20problem%20when%20trying%20to%20generate%20unique%20identifiers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhenever%20I%20insert%20a%20new%20row%20from%20the%20canvas%20app%2C%20I%20want%20the%20Excel%20File%20to%20give%20a%20unique%20identifier%20for%20that%20newly%20created%20row.%20So%20far%2C%20I've%20run%20into%20the%20following%20problems%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1-%20If%20the%20identifier%20is%20set%20by%20the%20canvas%20app%2C%20then%20I%20bump%20into%20concurrency%20issues%20(if%20two%20users%20use%20the%20app%20and%20create%20a%20new%20row%2C%20two%20rows%20will%20be%20created%20with%20the%20same%20identifiers)%3C%2FP%3E%3CP%3E2-%20The%20use%20of%20formulas%20in%20the%20excel%20online%20file%20is%20not%20supported%20when%20using%20the%20PowerApps%20connector%2C%20so%20I%20cannot%20use%20formulas%20to%20give%20the%20desired%20value%20to%20the%20%22id%22%20column%3C%2FP%3E%3CP%3E3-%20Office%20scripts%20does%20not%20support%26nbsp%3B%20binding%20to%20events%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20using%20Google's%20Spreadsheets%20and%20you%20can%20there%20bind%20a%20function%20to%20the%20%22onChange%22%20event%2C%20which%20is%20triggered%20both%20when%20a%20user%20or%20PowerApps%20modifies%20the%20spreadsheet.%3C%2FP%3E%3CP%3EI'd%20need%20something%20similar%20with%20Excel%20Online%2C%20as%20it's%20absurd%20that%20I%20need%20to%20use%20Google's%20services%20when%20my%20organization%20uses%20Office%20365...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20also%20been%20looking%20into%20the%20Office%20add-in%20documentation%2C%20but%20I'm%20quite%20uncertain%20that%20this%20scenario%20is%20feasible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1432999%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

Hi,

I'm using Excel Online Connector alongside a PowerApps Canvas App and got a problem when trying to generate unique identifiers.

 

Whenever I insert a new row from the canvas app, I want the Excel File to give a unique identifier for that newly created row. So far, I've run into the following problems:

 

1- If the identifier is set by the canvas app, then I bump into concurrency issues (if two users use the app and create a new row, two rows will be created with the same identifiers)

2- The use of formulas in the excel online file is not supported when using the PowerApps connector, so I cannot use formulas to give the desired value to the "id" column

3- Office scripts does not support  binding to events

 

I've been using Google's Spreadsheets and you can there bind a function to the "onChange" event, which is triggered both when a user or PowerApps modifies the spreadsheet.

I'd need something similar with Excel Online, as it's absurd that I need to use Google's services when my organization uses Office 365...

 

I've also been looking into the Office add-in documentation, but I'm quite uncertain that this scenario is feasible.

 

Any ideas?

 

0 Replies