Unanswered

Dataflow to excel fixed column and rows

Like (1) Share

Report

Posted on 6 Jul 2024 15:28:32 by PN-13051647-0

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.

Categories:

Dataflows

I have the same question (0)

All responses (2)

Answers (0)

PN-13051647-0 22 on 07 Jul 2024 at 07:03:48

Like (0)

Report

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.

Was this reply helpful? Yes No
Michael E. Gernaey 48,204 Super User 2025 Season 2 on 07 Jul 2024 at 03:05:21

Like (0)

Report

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

Was this reply helpful? Yes No