I'm new to O365 and Scripting. I hope someone can help me!
Using a script, I would like to take the latest entry from a cell in excel (added from a Microsoft form) and compare that cell value to a column of data in the excel workbook (different worksheet). If the value is unique I would want the script to pass that to Power Automate to email that value out.
The flow I think would work is:
- New entry in Microsoft Form (Triggers Power Automate to run script in excel)
- Script does comparison. Result: No unique values or unique values.
- If there are unique values Power Automate emails those values out.
