Unanswered

How to differentiate between Folders and Files when using the Sharepoint triggers?

Like (0) Share

Report

Posted on 19 Jun 2018 10:44:17 by goderis

The Sharepoint trigger "When a file is created or modified" is triggered for both Folders as well as Files

So, when ones creates a new file, the trigger is fired once for the File, and once for the Folder if it happen to be created during that call. However, there is no output field in the trigger that indicates that the event was triggered for a File or a Folder.

Is there a work-around to differentate both cases? The only thing I can think of is to classify files as having at least a "." in the FileName With Extension field, but extensions are not a mandatory thing on some OSs (at least, I think so)

I have the same question (0)

All responses (3)

Answers (0)

Lübbe 27 on 25 Oct 2022 at 12:47:05

Like (0)

Report

Re: How to differentiate between Folders and Files when using the Sharepoint triggers?

... this is an old issue, so may be 2018 or 2020 the following field wasn't there ...

Today I just use the field {IsFolder} in the triggerBody.
And instead of testing this inside the flow, I added the regarding condition @not(triggerBody()?['{IsFolder}']) directly to the trigger, so the flow only starts, if the created or changed item is not a folder.

Happy coding, Lübbe

Was this reply helpful? Yes No
Meena_Makwana on 20 Feb 2020 at 21:44:48

Like (0)

Report

Re: How to differentiate between Folders and Files when using the Sharepoint triggers?

Hi Mabel,

The solution you suggested is working. Thanks for Sharing 🙂

Regards,
Meena Makwana

Was this reply helpful? Yes No
v-yamao-msft on 21 Jun 2018 at 07:26:07

Like (1)

Report

Re: How to differentiate between Folders and Files when using the Sharepoint triggers?

Hi @goderis,

According to your description, I crated a flow with the trigger “When a file is created or modified (properties only)”, I found that it will be also triggered when a folder is created or modified.

If you want to differentiate between folders and files, you could use the dynamic content File name with extension from the trigger.

To test this issue, I created a simple flow likes below. I configured the Condition as File name with extension contains ‘.’. Then when a folder is created, no notification will be sent.

Please take the following screenshot for a reference.

Best regards,

Mabel Mao

Was this reply helpful? Yes No