web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / connecting excel workb...
Power Automate
Answered

connecting excel workbooks and updating specific columns

(0) ShareShare
ReportReport
Posted on by 2

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.

Categories:
I have the same question (0)
  • Verified answer
    v-litu-msft Profile Picture
    on at

    Hi @hazeleyes86,

     

    It seems that you have posted the same question, for other helpers to easily identify, please following this original post:

    Connecting 2 excel workbooks and updating columns - Power Platform Community (microsoft.com)

     

    Best Regards,
    Community Support Team _ Lin Tu

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard