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 / How to auto update a c...
Power Automate
Unanswered

How to auto update a cell in excel with a new response ID and then print a separate tab within excel.

(0) ShareShare
ReportReport
Posted on by 6

Hi all, looking for any advice on creating a flow to auto update a cell and auto print another tab within the same excel document.

 
The details of the current situation:
1. I have an excel file connected to a MS Form (which includes questions like name/address etc etc ).

2. As responses are received into excel from Forms (into tab named FORM1), the user manually enters the response ID into cell D1 on FORM1. 

3. There is a separate tab (named DOCUMENT) that is linked to D1 of FORM1, and through formula in DOCMUENT, as the ID# is updated in D1/FORM1, all the individual answers for that particular response are automatically updated and create a client facing document that is then manually printed.

 

What I would like to create:

The above process is manual, so I would like to create a flow that as each response is recorded in Excel, the ID is automatically populated into cell D1 of FORM1 and then the tab named DOCUMENT is printed. 

Is something like this possible, or too complicated??

Greatly appreciate any assistance you can provide!

Categories:
I have the same question (0)

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…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard