Power Platform Community Forum Thread Details

connecting excel workbooks and updating specific columns

Hello, I wanted to kindly ask for assistance with Power automate flow please. I have two excel workbooks in one drive: one is my personal tracker workbook that has several columns but I only want to automate two columns named Audit 1 and Audit 2. Based on the data I am auditing, when complete in the Audit 1 column I will always type the word "complete" in every single row, and Audit 2 I will always type the phrase "ready to file". in that column for every row. The other workbook is the master tracker, which is tracked by supervisors. It has different columns than my master tracker, the only exception are Audit 1 and Audit 2 based on what I enter in my personal tracker. They want to track my progress and see when these audits are complete in this master tracker. So my question is each time I update Audit 1 and Audit 2 columns in my own tracker workbook, how can I make it so that the master tracker workbook Audit 1 and Audit 2 columns also update with the same data? Thank you for any insight and help! I am new to automate.

Quick Links

Leaderboard