Unanswered

Birthday Email to Include Random Images

(0) Share

Report

Posted on by sandeepcrush

We have created a flow to send birthday emails to employees, its working as expected fetching the data from sharpeoint list. however the HR team wanted random images to be included in the email, in the email body i couldn't see an option to include picking of random images from may be a pool of 5 images each time when it send the email.

i know that we can use JavaScript in html to achieve this, however with msflow JS wont work is what i know. any way that i could achieve this , appreciate the help

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @sandeepcrush,

if you are confident attaching files to an email, why don't you use the function rand(1,5) to generate a random number from 1 to 5 and using that answer look up an image with column image number 1 to 5 in a sharepoint list? Or have a condition statement for image 1 to 5 based on the random number.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
sandeepcrush 14 on at

Like (0)

Report

Thanks @DamoBird365 , let me try this , do you have any examples of such scenarios?

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (2)

Report

Hey @sandeepcrush

I've tried it myself. You could use a list but thought of an even easier way. You can simply save the images to your document library as 1,2,3,4,5.jpg etc.

Then use rand(1,5) in a compose and use the compose string in the ile identifier.

For the file identifier, I had to convert / and spaces into unicode hex.

For example
%252fShared%2bDocuments%252fGeneral%252f3.jpg
OR
%252fShared%2bDocuments%252fGeneral%252f@{outputs('Compose')}.jpg

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
ajdhingr Microsoft Employee on at

Like (0)

Report

@DamoBird365 Thanks for sharing. @sandeepcrush were you able to resolve your issue ?

Was this reply helpful? Yes No
pradeep_kumar 42 on at

Like (0)

Report

Hi

i want to insert image in email body but match numbers of work years and image number and embedded image in email body such as

teammate years number 1=1(image name) that insert in email body

Was this reply helpful? Yes No
aakkuummaarr 46 on at

Like (0)

Report

Hi @DamoBird365 ,

What is the Concat you have used in Attachment Name please?

Was this reply helpful? Yes No