Unanswered

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Mitanshu 1,650 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

v-duann-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No