Forum Discussion

eahbxecrfash3q's avatar
eahbxecrfash3q
Brass Contributor
Jul 29, 2025

Support Needed: Streamlining ID Comparison Process

Hi everyone,

About once a month, the Workday (WD) team posts updates to the cost center hierarchy, which are documented in the WD Report spreadsheet. This spreadsheet contains two tables on different sheets: "Changes" and "Deletions." Both tables have "ID" as the first column.

We maintain our own spreadsheet, called the Master List, which includes a table named "AllClaims." This table lists all our security groups that might be impacted by these changes. The "AllClaims" table has "Group Name" as the first column, with cells containing values in the format "ID Name."

I need to identify rows in the "AllClaims" table where the "ID" part of the "ID Name" value matches an "ID" in either the "Changes" or "Deletions" tables. I am trying to accomplish this with a flow, but I haven't found a simple and efficient method yet.

Below is a screenshot of my current flow. Could someone please guide me on where I might be going wrong and how I can achieve this? Thank you!

 

excel
microsoft teams

1 Reply

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Jul 30, 2025

    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.

Resources