First Flow

[aazza91]

Hi,

Looking to build only my 2nd flow (first was quite basic). I'm looking to see if it is possible, and if so.. how?

I'm part of a charity football club who are looking to automate as much of our processes as possible, in particular with new player registrations.

Is it possible to build a flow which sends a "welcome to the club" email which contains a welcome back PDF when a new response is triggered. The email address to send too would of course be an answer within the form.

Thanks,

Aaron

[Andrew_J]

@aazza91 

Welcome to the fun world that is Power Automate, that some of still call Flow because we are old school.

Yes you can do what you want to do.  Can you please let me know what you are currently stuck on and I will try and help.

Regards,

Andrew

[aazza91]

Hi Andrew,

I actually have tried to do some research and I am thinking it may be quite complex.

Firstly within our form we ask players or parents which team they are registering for (we have multiple options)

There is also another part of the form which asks them for their email address.

We want to email this email address with a specific email along with an attachment (or a link to a file) for each individual team.

Thanks,

Aaron

[Andrew_J]

Hi Aaron,

Thanks for the responce, what I surgest you do is to setup a database in SharePoint, that has the same fields as your Form.  The fields in the SharePoint list should not have any spaces, so for instance First Name should be FirstName.

Then use the following as start for your flow:

https://make.powerautomate.com/environments/Default-ec4135c9-2ac4-4f57-9e35-b481d071006f/galleries/p...

I would suggest that you need to setup a new SharePoint site for all of this registration process.  I would name it PlayerData or whatever you want to call it.  The new SharePoint List should also be stored in there.  I will leave you to think of a name for the SharePoit list.

You will need to uplaod your Welcome Pack PDF to the Document Library in the SharePoint Site.

So if you can get all the above done we will work together on the complicated bit to get the file attached and send the email.

Regards,

Andrew

[aazza91]

Thanks Andrew! I couldn't get your link working but have found another link and I have almost cracked it.

I have the flow set up as below:

The issue I have now is when the email sends the PDF pulls through as a blank PDF with the correct number of pages.

[Andrew_J]

@aazza91 

Great to see you have mastered some of this already.

Can you please expand the following sections:

Can you please change the flow designer to the classic view before you copy and paste the screen grab into your responce.  Then adust the snip to fill the whole width of the screen.

I think we can solve this quite easily I just need to see the prt of the flow requested.

I shall nto be able help you in five hour time as I am going out.  It is 1315 in the UK where I am from.

Regards,

Andrew

[aazza91]

Hi,

I hope that is everything there?

Thanks

[Andrew_J]

@aazza91 

Thanks that helps a lot, you have not got it quite right so I hope the below will help.

Go to the send email step as below and hit the red square:

This should bring up a text box which you need to type into:

Add the following basic text:

[

{

"Name": "INSERT Filename.pdf";

"Contentbytes": filecontent

}

]

The red text is dynamic and should come from the GET FILE PROPERTIES step above. 

Hopefully after saving and testing the flow should work and the PDF should display correctly.

I have been to your fair city a lovely place full of a lot of history that includes my Family.

Regards,

Andrew

[aazza91]

There is certainly worse places to live!

I am still struggling to get this to work.

It is still pulling through as a blank PDF.

[Andrew_J · Accepted solution]

@aazza91 

It should be as follows:

Make sure it like the above apart from the filenane chanage my test1.pdf to your name.

I have tested it with a PDF and it opens and displays the images in.

Andrew

[aazza91]

Hi Andrew.

It worked! I changed the file name, but when I went to edit it I noticed Power Automate automatically puts the file content look up within exclamation marks. I removed these and it worked so thank you!

[Andrew_J]

@aazza91 

Good news, flow can be quite finicity at times, so do not dispare you will get there.

I will DM sometime later on today.  But I hope the matches go well over the weekend.

Regards,

Andrew