Thank you for choosing Microsoft Community.
This is a pretty cool automation project!
Here's a step-by-step approach that might help you out:
Extract the Excel Attachment: Use Power Automate to trigger when an email with an attachment is received. You can use the "When a new email arrives" trigger and then add a condition to check if the email has attachments.
Convert Excel to JSON: Once you have the attachment, use the "Get file content" action to read the Excel file. Then, use the "Excel Online (Business)" connector to read the rows from the Excel file. You can then use the "Create CSV table" action to convert the Excel data into a CSV format, and finally, use the "Parse JSON" action to convert the CSV data into JSON.
Create a Table in a File: Use the "Create file" action to create a new file where you will store the table. You can use the JSON data to populate this table.
Populate Word Template: Use the "Populate a Microsoft Word template" action to fill in the template with the data from the JSON. You will need to have a Word template with placeholders for the data you want to populate.
Save or Send the Populated Document: Finally, you can save the populated document to a specific location or send it via email.
This should give you a good starting point. If you need more detailed steps or run into any issues, feel free to ask!
If this Post helped you, please click "Does this answer your question" and like this post to help others in the community find the answer too!
Happy to help
Robu 1
40
Share
Report
All responses (
Answers (
