Support Needed: Streamlining ID Comparison Process

May consider Power Automate:

1. Trigger: Manual or scheduled (e.g. monthly)

2. Get Rows:

• • Use Excel Online (Business) connector to get rows from:
    • AllClaims table in Master List
    • Changes and Deletions tables in WD Report

3. Extract IDs:

• • • • For each row in AllClaims, use an expression to split the "Group Name" value:

split(items('Apply_to_each')?['Group Name'],' ')[0]

This grabs the ID portion before the space.

4. Compare IDs:

• • Use nested Apply to Each loops or filter arrays to check if the extracted ID exists in either Changes or Deletions.
  • You can use a Union of both tables to simplify:

union(ChangesIDs, DeletionsIDs)

5. Store Matches:

• • Append matching rows to a new array or write them to a new Excel sheet/table for reporting.