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.

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,029 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CU19101210-0 7 on at

Like
a
(0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No