Hi all!
I have a three-parter. I have built a SharePoint List with a custom form in Power Apps that includes approximately 55 fields. Here is what I am trying to accomplish (please forgive me, I am relatively new to this level of Automate):
- When a new item is created in this list, create a new folder in a designated SharePoint Document Library and name it the list item's Title + ID << I have done this! It is working just fine. Yay!
- Convert the new list item details from step 1 to a clean and formatted PDF (I am not looking to export the data as a table, but instead something similar to a completed PDF form)
- Save the new PDF from step 2 into the new folder created in step 1
I have read that the best way to accomplish part 2 of this (creating a PDF of the data) is to convert it first to HTML and then save a temporary html file in OneDrive, which can then be converted to PDF. I gave that a try and it is not going well... I have used the "Select" data operation and mapped out all of my columns, then used the "Create HTML table" data operation and threw the Select Body in there, and then used the OneDrive for Business "Create File" to choose the folder and name the file. When I run the flow, it does create a temporary HTML file to a One Drive folder, but it smooshes all the columns together and it includes all items in the list and not just the new item like I want. I am not sure how to limit it to the new item, format it, or how to get that temporary html file converted to a pdf and then saved back into the SharePoint folder.
Below are some screenshots to show what I have done so far. I would be greatly appreciative of any assistance! And remember, I am a relative novice here, so I beg you to explain any steps to me like I am a two year old.
THANK YOU SO MUCH
Step 1: When a new item is created:
Step 2: Create new folder:
Step 3: Get items:
Step 4: Select
Step 5: Create HTML table:
Step 6: Create file:
Result:
