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 / Does Power Automate ha...
Power Automate
Unanswered

Does Power Automate have the capability to do this?

(0) ShareShare
ReportReport
Posted on by 3

Hi Everyone! I've never used power automate, I'm having some difficulty starting this project and was wondering if anyone here could help- This is the current process: An import form (created in excel) is filled out and sent to an email address listed in the import form. The email recipient then uses the information in the import form to fill out a tracking sheet (created in excel), which is housed in a Microsoft team as a file. Does power automate have the capability to automatically transfer the emailed information from the import form to the tracking sheet (an email received could be the trigger)? If so, any ideas on where to start? Only specific data from the import form is needed in the tracking sheet. Please let me know if you need more information.

Categories:
I have the same question (0)
  • ScottShearer Profile Picture
    25,277 Most Valuable Professional on at

    @Superfly 

    You can accomplish your goal using Power Automate if the Excel data is in a table.  The data that you are importing must be in a table.  The data that you will be entering in the "tracking sheet" must also be entered in a table.

    If you are using tables, the rest is easy - let me know if you need an outline of the Flow.

     

     

  • Superfly Profile Picture
    3 on at

    Hi Scott,

    I appreciate your input! The tracking sheet can be seen first followed by the import form second. Each row in the tracking sheet resembles a new import form. Like I said before, only specific information from the import form (which I believe doesn't qualify as a table), is entered into the tracking sheet. Within the import form, there are several tabs where additional information is pulled from. Is the process I'm looking for still possible? Tracking Sheet.pngImport Form.png

     

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