cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Delvestio
Frequent Visitor

PowerApp to Word template, convert then to Pdf and then email recipient

Hello everyone,

 

I'm after a bit of help and guidance if you don't mind.

 

I have built a Canvas PowerApp that is designed to capture details of a telephone call and then send the results to a word template. I have formatted the word template using "designer" and everything works just fine.

 

I have designed this to capture the following:

 

  • Case Reference
  • Case Manager
  • Date and Time of Call
  • To | From
  • Incoming | Outgoing
  • Conversation Notes

These are all set to plain text content control. The user would either type the responses into the App of dictate using iPhone. 

 

I have then created 2 x PowerAutomate Flows:

 

1) Populate the word template, create a file in SP document library, convert that document to pdf and then create a second file (pdf) in the same SP document library. 

2) When a new file is created in SP document library, get the meta data and file content and if the file name is .pdf, send an email to a recipient attaching the pdf file. 

 

I had to create the Flows separately as no matter how much I tried I could not get the string to work as one flow. 

 

The problem I now have is on the second Flow I cannot program it to send the email to the creator / user of the PowerApp. The Dynamic options are simply not there. I guess this is because its a separate Flow. All users will be internal O365.

 

Question: How can I get this to work because the only option I have at present is to manually enter the email address of one recipient into the "Send Email (V2)" action whilst editing the Flow. This is no good as the Flow needs to identify the App user and then send the email to them. Would also be great if the Flow could send both word and pdf files (not sure how to do that either).

 

Some screen shots attached

 

 

 

1 REPLY 1
Delvestio
Frequent Visitor

More screen shots ...

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,384)