Creating headers dynamically

(1) Share

Report

Posted on by CU19101210-0

Hello Everyone,

Here i wanted to to know whether we can build the collection and its headers dynamically in power apps

So below in attached files one is my orginal data

Using the above data can i create a collection like the desired output in the picture attched bellow

So here the headers should not be done manually but it should be accordingly to the countries presnt in the original data and outcome should be like second table.
If its not possible in power apps how about in automate flow?
Can i send original data from power apps to the flow and how can i build a csv table as the second picture.

If anyone has ideas please let me know.

First attachment is the original data

second attachment is the expected output data

Thank you.

Categories:

Dataflows

168ae8eb-4049-482...

cdd42336-f5b7-48d...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

All responses (3)

Answers (0)

CU19101210-0 7 on at

Like (0)

Report

Creating headers dynamically

I am Sorry for the inconvinience here are my data and output data i need

original Data:

Desired Output:

so from the original data can i create the collection headers dynamically (i cant hardcore it as the countries may vary according to original data)
Michael E. Gernaey 40,272 Super User 2025 Season 1 on at

Like (0)

Report

Creating headers dynamically

Hi

same issue as Warren, can’t see your files.

However to clarify are you asking to Pivot on Country where it becomes the header horizontally?

and if so, then what are the “vertical” headers and data underneath

Bummer cannot see the data maybe take a picture for us.

To do it easily we would need to use DAX
WarrenBelz 146,524 Most Valuable Professional on at

Like (0)

Report

Creating headers dynamically

Hi CU19101210-0

Your files (they do not seem to be attachments) are not accessible here, but what you describe should be achievable in Power Apps "manually coding" the CSV structure, however if you want an actual file produced, you will probably need Power Automate.