Event Cross Reference

Cross reference and format Excel file

This project shows how two Excel files can be cross-refenced and formatted using Office Scripts and Power Automate.

The project achieves this -

1. Extracts event master (key) data from Event.xlsx using one Run script action.
2. Passes that data to second Excel file containing event transaction data and uses that data to do basic validation of data and formatting of missing or incorrect data using Office Scripts.
3. Sends the result to a reviwer via. email.

For further details see:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Cross-Reference-and-formatting-two-Excel-files-using-Office/td-p/728535

Video link

Office Scripts

Checkout the directory.

1. Get Event Master Data
2. Validate Event Transactions

Excel files used

1. Event master data
2. Event tranaction data