trigger instant code execution on modern list form submission. not flow which takes about a min

%3CLINGO-SUB%20id%3D%22lingo-sub-575723%22%20slang%3D%22en-US%22%3Etrigger%20instant%20code%20execution%20on%20modern%20list%20form%20submission.%20not%20flow%20which%20takes%20about%20a%20min%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-575723%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20want%20to%20do%20some%20calculattion%20on%20few%20fields%20of%20a%20list%20and%20put%20the%20content%20into%20a%20field%20of%20the%20same%20list.%3C%2FP%3E%3CP%3EThe%20calculate%20column%20does%20not%20work%20because%20it%20does%20not%20take%20lookup%20fields.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wrote%20powershell%20to%20hide%20a%20single%20line%20of%20text%20field%20and%20then%20used%20flow%20to%20make%20the%20claculation%20on%20item%20created%2Fmodified%20and%20populate%20the%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20it%20is%20not%20instant%20have%20to%20wait%20for%20few%20seconds%20to%20get%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20are%20the%20alternatives%20here%20to%20instantly%20trigger%20or%20append%20code%20on%20modern%20new%20for%20button%20submission.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686823%22%20slang%3D%22en-US%22%3ERe%3A%20trigger%20instant%20code%20execution%20on%20modern%20list%20form%20submission.%20not%20flow%20which%20takes%20about%20a%20min%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686823%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F52384%22%20target%3D%22_blank%22%3E%40null%20null%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you're%20talking%20about%20SharePoint%20Online%20and%20modern%20experience%20lists%2C%20I%20think%20you%20will%20want%20to%20go%20for%20PowerApps%20(either%20a%20PowerApps%20SharePoint%20form%20or%20a%20standalone%20PowerApp%20depending%20on%20your%20requirements).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20PowerApps%20you'll%20have%20access%20to%20the%20%22OnChange%22%20event%20for%20each%20field%2C%20after%20which%20you%20can%20run%20whatever%20calculations%2Flookups%20you%20need%20to%20run%20as%20the%20user%20fills%20out%20the%20form%2C%20then%20submit%20those%20values%20with%20the%20form.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Regular Contributor

Hi,

 

i want to do some calculattion on few fields of a list and put the content into a field of the same list.

The calculate column does not work because it does not take lookup fields.

 

I wrote powershell to hide a single line of text field and then used flow to make the claculation on item created/modified and populate the value.

 

However, it is not instant have to wait for few seconds to get this.

 

What are the alternatives here to instantly trigger or append code on modern new for button submission.

 

Thanks

1 Reply
Highlighted

@null null 

 

If you're talking about SharePoint Online and modern experience lists, I think you will want to go for PowerApps (either a PowerApps SharePoint form or a standalone PowerApp depending on your requirements).

 

With PowerApps you'll have access to the "OnChange" event for each field, after which you can run whatever calculations/lookups you need to run as the user fills out the form, then submit those values with the form.