Create an excel table using updates coming from Power Apps

[PowerAppNoob]

Hi Experts,

I have created a flow triggered by Power Apps where it sends an email summary to the power app user (responder) who submitted the form. The summary is in table form and is included in the body of the email.

Is it possible to create a excel file based on this table and make it as an attachment in the email to be sent to the responder?

I tried including 'Create CSV table' action in the flow but all the information are lumped in one cell instead of having separate columns.

Any help would be greatly appreciated.

[chrissahagun]

Checking this docu:

Understand data operations - Power Automate | Microsoft Docs

it says create CSV takes a JSON array input format.

Pardon this next question as it will sound like an IT Support guy asking if you plugged in the power... 😇

Can we confirm first that the input to your Create CSV table was in a form of a JSON Array?

[PowerAppNoob]

Hi @chrissahagun ,

Thanks for replying. Here's the flow that i have.

I am getting a CSV file as attachment to my email but the Column headers are all in one cell. Same as the items that are supposed to be separated into different columns.

[Jronash]

In your "Create CSV table" action, what do you have in the From field?  I see that it says Output, but I can't tell which output it is using.

Also, in your "Send an email" action, what do you have in the Attachements Content field?

[PowerAppNoob]

Hi @Jronash ,

This is what i have in the From field in the Create CSV table.

And the Email attachment is the Output from Create CSV table.

[Jronash]

Hmm, I'm not able to replicate this problem.

I guess the next step would be to go to the run history of the flow and examine the outputs of your Select action and your Create CSV Table action, to see if you can tell where the problem is happening.

I'm also not sure I understand why you are using a Select action to map the columns you want, and then mapping the same columns in your Create CSV Table action.  Couldn't you just set the Create CSV Table action to get its data directly from Filter Array?  Though you may have reasons for structuring it this way, and in theory it shouldn't be the reason why your csv file isn't being created properly.

[PowerAppNoob]

@Jronash , I used the Select action because i don't need all the columns from the source data. I removed the mapping of columns in the Create CSV table. The CSV file still just have 1 column where all the headers are mixed together, separated by comma.

[Jronash]

Have you gone into your run history and examined the output from the Select action and the Create CSV action?

If there is no confidential information, are you able to post the outputs here?