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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dataflow to excel fixe...
Power Apps
Unanswered

Dataflow to excel fixed column and rows

(1) ShareShare
ReportReport
Posted on by 22

Hi

 

I have an excel workbook that I want to create formula with data from a separate sheet.  Is there a way I can export and import data from a record to the excel sheet that is use as my lookup?  I need these to be fixed columns and rows since I have formulas that will reference to them.

 

Thank you in advance.

I have the same question (0)
  • Michael E. Gernaey Profile Picture
    52,965 Super User 2025 Season 2 on at
    Re: Dataflow to excel fixed column and rows

    Hi @pnguyen1241 

     

    I am sorry I am not following, can you add a step by step run of what you mean?

     

    Just by reading it though I would say yes, I would use a Power Automate Flow. 

    Depends on if it runs on a Schedule, manual, triggered by a Power App, Triggered FLow etc


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • PN-13051647-0 Profile Picture
    22 on at
    Re: Dataflow to excel fixed column and rows

    Hi Mike, I want on a click of a button for a selected record, export that record data to excel via excel template. I need it export in a fixed column and row. This is because in the template I have another sheet with formulas that will reference to the data exported. 

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 Apps

#1
WarrenBelz Profile Picture

WarrenBelz 836 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 231 Super User 2025 Season 2

Last 30 days Overall leaderboard