Trying to create an onboarding document based on request input?
Hi,
So we have a request template where a manager would fill out various values, such as name, phone number, location, company and so on. Once that is done, i would like to be able to trigger a function that would generate a PDF or XLSM file with the values of the new employee that looks presentable.
Something that would look like:
| Start date | |
| Name | |
| Company | |
| Location | |
| Title | |
| Business unit / area | |
| Landline telephone | |
| Mobile phone | |
| Birthday |
|
| Requested by | |
| Created by | |
However, it seems to be more difficult than i anticipated.
I tried to create a function that sends the table as a mail. But all the values come back as "null"
I added the values in the script like:
lastName = context.get("udf_sline_3303");
company = context.get("udf_pick_1217");
location = context.get("udf_sline_21");
and then used the mail notification to output a table, which i wanted to send to Power Automate to convert it to a PDF. But i was hoping that there is a better way of generating such a document.
Sadly print preview of the ticket is not formatted correctly and is not something i would feel comfortable sending to a new user.