Power Platform Community Forum Thread Details

Hello, I could use some help. I have an excel file that we use to keep track of new hires. It has a single table in it with about 8-10 columns. We want to be able to enter the information in an excel file (we get about 20 new hires a week) and have it automatically take that information, organize it into a PDF file, and then attach that to an email and send it to the new email address (which is one of our columns) as well as CC someone else.

I've gotten it to the point where I have it create the PDF file, but its taking the output from excel as one line across the top of the document. Its not wrapping or putting columns on separate lines so a chunk of it is getting chopped off.

An example is:

Column A is FirstName | Column B is LastName | Column C is new email address | Column D is EmployeeID ....

Column Headers.png

So ideally in a PDF file I'd like it to output it something like this example:

NHO Sheet Example.png

Current output:

Actual Output.png

Is there any way to remove the @OData.etag and iteminternalID?

One other thing, when its sending me the emails with the PDF files, its coming encrypted, is there anyway to disable that somehow? Not sure if some folks will be able to figure out rights management or if they are trying to view on their phones what that might do.

Happy to post my current flow if it would be helpful!

Thanks,

Categories:

Building flows