Comparing a Cell with a Column of Data

%3CLINGO-SUB%20id%3D%22lingo-sub-2434841%22%20slang%3D%22en-US%22%3EComparing%20a%20Cell%20with%20a%20Column%20of%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2434841%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20new%20to%20O365%20and%20Scripting.%20I%20hope%20someone%20can%20help%20me!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20a%20script%2C%26nbsp%3BI%20would%20like%20to%20take%20the%20latest%20entry%20from%20a%20cell%20in%20excel%20(added%20from%20a%20Microsoft%20form)%20and%20compare%20that%20cell%20value%20to%20a%20column%20of%20data%20in%20the%20excel%20workbook%20(different%20worksheet).%26nbsp%3BIf%20the%20value%20is%20unique%20I%20would%20want%20the%20script%20to%20pass%20that%20to%20Power%20Automate%20to%20email%20that%20value%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20flow%20I%20think%20would%20work%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3ENew%20entry%20in%20Microsoft%20Form%20(Triggers%20Power%20Automate%20to%20run%20script%20in%20excel)%3C%2FLI%3E%3CLI%3EScript%20does%20comparison.%20Result%3A%20No%20unique%20values%20or%20unique%20values.%3C%2FLI%3E%3CLI%3EIf%20there%20are%20unique%20values%20Power%20Automate%20emails%20those%20values%20out.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2434841%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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:

 

  1. New entry in Microsoft Form (Triggers Power Automate to run script in excel)
  2. Script does comparison. Result: No unique values or unique values.
  3. If there are unique values Power Automate emails those values out.

 

0 Replies