You’re offline. This is a read only version of the page.
Share
Report
All responses (
Answers (
{
"inputs": {
"from": "@outputs('Compose-old')",
"select": "@item()['serial']"
}
}{
"inputs": {
"from": "@outputs('Compose-new')",
"where": "@not(contains(body('Select-old-serial'), item()['serial']))"
}
}{
"inputs": {
"from": "@outputs('Compose-new')",
"where": "@and(not(contains(body('Filter_array'), item())),not(contains(outputs('Compose-old'), item())))"
}
}Hi Hazza,
Thank you for choosing Microsoft Community.
To compare two Excel sheets and generate a digest of what rows have changed using Power Automate, you can follow these steps:
Steps to Compare Excel Sheets in Power Automate
2. Open Excel Files: Use the "Open Workbook" action to open both Excel files [
3. Read Data: Use the "Read Range" action to read the data from both sheets
4. Apply to Each Loop**: Use an "Apply to Each" loop to iterate through the rows of the first sheet
5. Find Matching Rows: Within the loop, use the "Find" action to search for matching rows in the second sheet
6. Check for Changes: Use conditions to check if the rows match or if there are any differences.
7. Create Digest: Add actions to create a digest of the changes, such as adding rows to a new table or sending an email summary.
Example Flow Structure
1. Open Excel Files:
- `Open Workbook` (First Excel File)
- `Read Range` (First Sheet)
- `Open Workbook` (Second Excel File)
- `Read Range` (Second Sheet)
2. Apply to Each Loop:
- `Apply to Each` (Rows in First Sheet)
- `Find` (Matching Row in Second Sheet)
- `Condition` (Check for Changes)
- If Match: Add to Digest Table
- If No Match: Add to Digest Table with Changes
3. Create Digest:
- `Create Table` (Digest of Changes)
- `Send Email` (Summary of Changes)
Additional Resources
- How to compare Excel Tables/Sheets in Microsoft Power Automate](https://www.youtube.com/watch?v=CRJXfVVhYrA)
- PowerAutomate: How to compare between 2 excel files items and get the matching result](https://www.youtube.com/watch?v=-odX-LeBJ5w)
If this resolves the issue pls mark as answered to enable others in the community find it.
Happy to help.
Robu1
#1
WarrenBelz
146,743
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,079
Most Valuable Professional
