Answered

Generate email based on file type uploaded to SharePoint Library

(0) Share

Report

Posted on by 12strikes

Hello all..
I have a library where multiple people are supposed to upload ONLY xlsx files. I need a flow that:
1. Is triggered when a file is uploaded that is NOT an xlsx (excel) file.
2. Sends and email to the person that did the upload and to 2 other people (administrators of the library). That has a standard "blurb" about the wrong file type, and has the name of the file, and the date and time the wrong file was uploaded.

Thanks All

All responses (2)

Answers (1)

Verified answer

v-duann-msft on at

Like (0)

Report

Re: Generate email based on file type uploaded to SharePoint Library

Hi @12strikes

Thank you for posting.

According to your description, you would like to restrict users only upload excel file to library. If any misunderstanding, please kindly let me know.

Here is the flow details:

Hope the content above may help you.

Thanks
Anna
Mitanshu 1,635 Super User 2025 Season 1 on at

Like (0)

Report

Re: Generate email based on file type uploaded to SharePoint Library

TL;DR: Use the expression to find if file is an .xlsx : endsWith(triggerOutputs()?['headers/x-ms-file-id'],'.xlsx')

Details:
Step 1 : Automated Flow (when a new file is created in SharePoint Folder)
Step 2 : Condition using expression listed above
Step 3 : if false, send an email saying wrong file type
Step 4 : if true, do nothing

Under this method, you will be wasting your daily Flow runs allowance as whenever an .xlsx is uploaded the Flow will run and do nothing. To mitigate this, you can add a trigger condiiton to your flow.

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