Answered

Send an email to staff with a random image from a Onedrive folder

(0) Share

Report

Posted on by Fshaw213

I am trying to send an email to staff with a random image from a onedrive folder. I am not sure where it is going wrong, any help would be great.

Screenshot 2022-10-12 114211.jpg

Categories:

General topics

I have the same question (0)

All responses (15)

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Fshaw213
You should use another action before this, like list files in a folder. Then get id of a file, maybe the first file as you are sending random images.
Btw how are you getting that id????

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (0)

Report

Part of the problem is the @{ I think that is preventing the compose output from being resolved to it's actual value. That's why you are seeing that as part of the literal output.

Was this reply helpful? Yes No
Fshaw213 16 on at

Like (0)

Report

Hey no luck, it just returns the same error. I copied the gauide from this post https://powerusers.microsoft.com/t5/Using-Flows/Birthday-Email-to-Include-Random-Images/td-p/831741

Was this reply helpful? Yes No
Fshaw213 16 on at

Like (0)

Report

When I do it this way it creates the appropriate output but it doesn't recognise the file.

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (1)

Report

That action is looking for guid, not name. The example you copied from is sharepoint, which i wouldn't be surprised if the example as shown didn't/doesn't work either for the same reason that the action typically looks for a guid. If you use the folder icon and browse to the file you want then under the elipse, look at peek code, you'll see it's resolved to a guid.

Try changing your get file content to be a Get file content using path action instead. That should accept the dynamic path you are trying to send it.

Was this reply helpful? Yes No
Fshaw213 16 on at

Like (0)

Report

It's close, now I don't know why but it doesn't send it as a jpeg it just sends it as a file.

Was this reply helpful? Yes No
Verified answer

srduval 1,760 Moderator on at

Like (1)

Report

Somewhere in the attachment process you should be specifying a name, make sure you add the extension (4.jpg)

Was this reply helpful? Yes No
pradeep_kumar 42 on at

Like (0)

Report

But I want to embedded these randomly image on an email body

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

The flow to add a randomly-selected image from a OneDrive folder to an email is as follows:

Add a OneDrive get file content action and add the expression
outputs('List_files_in_folder')?['body/value'][rand(0,length(outputs('List_files_in_folder')?['body/value']))]?['Id']

Then in the Send an email action, click the code view </> button and oin the img src line add the expression

dataUri(outputs('Get_file_content')?['body'])

Run the flow and an email will arrive with a random image from the OneDrive folder:

Run it again and a different random image will be in the email:

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
pradeep_kumar 42 on at

Like (0)

Report

Hi,

Thanks for reply but i want to insert image in email body then i work on that such as insert teammate name on that image and insert some another image on that

Was this reply helpful? Yes No