How to give the two folder paths in when a file is created or modified trigger

Question

How to give the two folder paths in when a file is created or modified trigger

Podili Vijay 20

I'm able to give two paths in when a file is created or modified trigger.using below code @or(startsWith(triggerBody()['{Path}'], 'Shared Documents/source/'),startsWith(triggerBody()['{Path}'], 'Shared Documents/General/')) But my paths are Shared Documents/QUERY NEW/Country/PB/Actuals/QUERY Results/Mar-2023/QueryFeb_ 2023 QueryRefredhAs on 05032024 NOTE:Feb is the last month and my second expression is till Shared Documents/New/jack/2023/Mar/05-Mar/solution-v3 .xlsx so on the second path if we create the date month folder then also logic app will trigger how to avoid these case i want to trigger the logic app only when file is uploaded in the path. @MayankBargali-MSFT can any one know the answer

Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-05T19:59:38.9433333+00:00

Hi! I would like to help you, but could you please elaborate a bit more on what you’re trying to do and the use case? I don’t fully understand what the goal is.
Podili Vijay 20 Reputation points

2023-03-06T03:10:07.4633333+00:00

Thank you sonigillissen Step-1 how to add two folder path in when a file is created or modified i was able to add two paths using these expression on trigger settings @or(startsWith(triggerBody()['{Path}'], 'Shared Documents/source/'),startsWith(triggerBody()['{Path}'], 'Shared Documents/General/')) Above are the my paths Step2: if I added above expression ii doesn't work my requirements. If I added a date or month r year folder then also logic app will trigger. So I want to trigger my logic app only when a file is created in the folder how can I implement these case
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-06T05:30:23.5866667+00:00

Thanks for your clarification! I will set up a small test lab and perform some tests myself, and will get back to you with an answer asap.
Podili Vijay 20 Reputation points

2023-03-06T07:46:19.8066667+00:00

Thank you @Sonny Gillissen

1 answer

Your answer

Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-05T19:59:38.9433333+00:00

Hi! I would like to help you, but could you please elaborate a bit more on what you’re trying to do and the use case? I don’t fully understand what the goal is.
Podili Vijay 20 Reputation points

2023-03-06T03:10:07.4633333+00:00

Thank you sonigillissen Step-1 how to add two folder path in when a file is created or modified i was able to add two paths using these expression on trigger settings @or(startsWith(triggerBody()['{Path}'], 'Shared Documents/source/'),startsWith(triggerBody()['{Path}'], 'Shared Documents/General/')) Above are the my paths Step2: if I added above expression ii doesn't work my requirements. If I added a date or month r year folder then also logic app will trigger. So I want to trigger my logic app only when a file is created in the folder how can I implement these case
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-06T05:30:23.5866667+00:00

Thanks for your clarification! I will set up a small test lab and perform some tests myself, and will get back to you with an answer asap.
Podili Vijay 20 Reputation points

2023-03-06T07:46:19.8066667+00:00

Thank you @Sonny Gillissen

Answer 1

Sonny Gillissen 3,751 Volunteer Moderator

Hi,

I've tested your question in my test lab, and it works as expected. When I add the code you wrote to my trigger condition it only triggers when files are added in /General or /source (and subfolders), but not in other root folders.

Just to make sure it's in the right place, I've set my trigger to fire on the root folder of my site collection, the clicked the "three dots" and selected "Settings":
User's image

Next I've added your code to the trigger condition:

User's image

For completeness, I've used this code:

@or(startsWith(triggerBody()['{Path}'], 'Shared Documents/source/'),startsWith(triggerBody()['{Path}'], 'Shared Documents/General/'))

It works as expected.

I've added my Logic App code for your reference (you can copy/paste it but be sure to change the following details to your own (for the connection part you could also reuse from your current Logic App):

{SiteCollectionUrl} to your Site Collection's URL
{DocumentLibraryGuid} to your Site Collection's document library GUID
{SubscriptionId} to the Azure subscription ID of your Logic App and connection file
{ResourceGroupName} to the name of your Logic Apps' resource group
{Location} to the location your resource group is in

{
    "definition": {
        "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
        "actions": {},
        "contentVersion": "1.0.0.0",
        "outputs": {},
        "parameters": {
            "$connections": {
                "defaultValue": {},
                "type": "Object"
            }
        },
        "triggers": {
            "When_a_file_is_created_or_modified_(properties_only)": {
                "conditions": [
                    {
                        "expression": "@or(startsWith(triggerBody()['{Path}'], 'Shared Documents/source/'),startsWith(triggerBody()['{Path}'], 'Shared Documents/General/'))"
                    }
                ],
                "evaluatedRecurrence": {
                    "frequency": "Minute",
                    "interval": 3
                },
                "inputs": {
                    "host": {
                        "connection": {
                            "name": "@parameters('$connections')['sharepointonline']['connectionId']"
                        }
                    },
                    "method": "get",
                    "path": "/datasets/@{encodeURIComponent(encodeURIComponent('{SiteCollectionUrl}'))}/tables/@{encodeURIComponent(encodeURIComponent('{DocumentLibraryGuid}'))}/onupdatedfileitems"
                },
                "recurrence": {
                    "frequency": "Minute",
                    "interval": 3
                },
                "splitOn": "@triggerBody()?['value']",
                "type": "ApiConnection"
            }
        }
    },
    "parameters": {
        "$connections": {
            "value": {
                "sharepointonline": {
                    "connectionId": "/subscriptions/{SubscriptionId}/resourceGroups/{ResourceGroupName}/providers/Microsoft.Web/connections/sharepointonline",
                    "connectionName": "sharepointonline",
                    "id": "/subscriptions/{SubscriptionId}/providers/Microsoft.Web/locations/{Location}/managedApis/sharepointonline"
                }
            }
        }
    }
}

Please let me know if my answer is helpful, and if so click "Accept answer" and upvote it. Feel free to drop additional queries in the comments below.

Podili Vijay 20 Reputation points

2023-03-06T12:30:07.3566667+00:00

@or(startsWith(triggerBody()['{Path}'], 'Shared Documents/source/'),startsWith(triggerBody()['{Path}'], 'Shared Documents/General/'))---> these is my code @or(startsWith(triggerBody()['{Path}'], 'Shared Documents/source/'),startsWith(triggerBody()['{Path}'], 'Shared Documents/General/'))---->these is your code botha re same
Podili Vijay 20 Reputation points

2023-03-06T12:33:27+00:00

But these is my my actual path abc/def/mar-2023--->first path,abc/def/2023/mar/06/fgh.xlsx so if create the date or month or year folder then also logic app will trigger how we can overcome these situation @Sonny Gillissen
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-06T12:52:27.56+00:00

Yes, I’e included your code to test. But I think we misunderstood each other.

If I’m correct you want the Logic App to trigger on abc/def/mar-2023 but not on the underlying subfolders?

Think the best approach for this would be to change the ‘startsWith’ functions with ‘equals’.

Subfolders will always start with the same path as your root folder, thus ‘startsWith’ is not sufficient. Using ‘equals’ the path must be the same as the one in your expression, ruling out any of the subfolders.

The expression will then look like this:

@or(equals(triggerBody()['{Path}'], 'Shared Documents/source/'),equals(triggerBody()['{Path}'], 'Shared Documents/General/'))
Podili Vijay 20 Reputation points

2023-03-06T13:12:11.6366667+00:00

Thank you @Sonny Gillissen i think it was working so next step is how we can compare the file name using condition or anything because if file will upload in one path secondpath action will failed so if we used condition action it was check the file name if the file will upload in desired path that action will excute true reaming will excecute false how we can implement these case
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-06T14:16:12.1+00:00
You're now using {Path} for your trigger condition, so I think if you'd like to check on filename there are two options:

Change {Path} to {FullPath} to check for your filename, including path

Or change {Path} to {FilenameWithExtension} to check on the filename only

Your syntax will then respectively look as follows:

@or(equals(triggerBody()['{FullPath}'], 'Shared Documents/source/filename.ext'),equals(triggerBody()['{FullPath}'], 'Shared Documents/General/filename.ext'))

Or:

@or(equals(triggerBody()['{FilenameWithExtension}'], 'filename.ext'),equals(triggerBody()['{FilenameWithExtension}'], 'filename.ext'))

However, I'm curious about why you would want to check on filename? My advise would be to let the filename be generic, and let the folder decide whether or not you upload it (as filenames tend to be error prone).
Podili Vijay 20 Reputation points

2023-03-06T14:48:29.13+00:00

Thank you for your response @Sonny Gillissen but the thing is one of file name will maintain year month date like Query_ Feb_ ason_06032023.xlsx here Feb is the last month and we don't hard code the year month date in the file so how we can give the file in expression.
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-06T15:32:00.83+00:00

I see! For the month name ‘feb’ its doable through the formatDateTime() function using ‘MMM’ as format string. However, the date at the end is challenging.

During the Logic App run you would use an “Inline Code” action to perform RegEx, because I believe RegEx is the only way to properly solve this. But this is not possible in the trigger conditions.

The only option would then be to always trigger your Logic App, on any file, and use the Logic App actions (like “Inline Code” for example) to check if the file should be processed or not. I don’t think your use case is supported in any other way.

Only downside: triggering and actions cost a bit of money on every triggered run, so basically you would pay a bit for every file, be it processed or not. This is not the case when using a Logic App Standard though.

Another option would be to let the files to process always land in a specific directory, which enables you to leverage the trigger conditions (thus saving money).
Podili Vijay 20 Reputation points

2023-03-06T16:08:12.4833333+00:00

@Sonny Gillissen i didn't understand what your trying to tell me is it not possible for a above file scenario
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-06T16:57:47.8033333+00:00

It isn’t possible in the trigger condition to perform a RegEx. So your solution should not be containing trigger conditions, but just let the trigger pick up every file.

Next, create a piece of ‘Inline Code’ action to perform the RegEx, and add a ‘Condition’ access to check if the file should be processed.
Podili Vijay 20 Reputation points

2023-03-06T17:06:21.32+00:00

@or(equals(triggerBody()['{Path}'], 'Shared Documents/source/'),equals(triggerBody()['{Path}'], 'Shared Documents/General/'))---->these solution is not working @Sonny Gillissen if I use these path logic app did not trigger after uploading the file in logic app. @or(startsWith(triggerBody()['{Path}'], 'Shared Documents/source/'),startsWith(triggerBody()['{Path}'], 'Shared Documents/General/'))--->if I use logic app will trigger can you check above expression in your work area
Podili Vijay 20 Reputation points

2023-03-06T17:07:15.1+00:00

Can you give me the implementation steps for condition statement
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-07T05:39:17.03+00:00
Basically it comes down to:

Trigger your Logic App without any conditions, so every file comes in

Add a "Inline Code" action directly after the trigger, containing a bit of code to check whether the file can be processed or not (for example using RegEx) and return true when it can be processed

Then, add a "Condition" action which checks for the return of the "Inline Code" piece to be true or not

In the "True" section of the "Condition", add all actions necessary to process the file

For the steps above I'd advise you to switch to a Logic App Standard, if you don't have one yet. As the "Inline Code" action requires an Integration Account when using Logic App Consumption.

Another option could be, when you want to use Logic App Consumption, to turn step 2 into a Function App containing the code for checking the file to be processed and returning true or false. The rest of the steps will then be kinda the same.
Podili Vijay 20 Reputation points

2023-03-07T09:33:29.5066667+00:00

@Sonny Gillissen thank you for your response can you show me with one practical examples i don't know inline code i did not understand what you try to saying
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-07T11:21:52.49+00:00
Sure! In this example we're doing the following:

We've removed the trigger conditions from the trigger, so every documents gets passed in

A compose action is added for retrieval of the filename with extension (as the {} in the JSON are something not handled well by JavaScript

Next we've added the inline code to perform a RegEx on the filename to check: does it start with Query_ followed by the 3-letter abbreviation of the mont and next contains ason followed by 8 digits and lastly .xlsx

The inline code above returns true when the filename matches the RegEx, so we've added a condition to check if the result from the inline code is true

In the true block all following actions can be added for processing the document

The code used in this example is the following:

const fileName = workflowContext.actions.Compose.outputs; const regex = new RegExp('^(Query_)(J(?:an?)?|F(?:eb?)?|M(?:ar?)?|A(?:pr?)?|J(?:un?)?|J(?:ul?)?|A(?:ug?)?|S(?:ep?)?|O(?:ct?)?|N(?:ov?)?|D(?:ec?)?)(_ason_)\\d{8}(.xlsx)'); if(regex.test(fileName)) { return true; } else {return false; }

Containing this RegEx:

^(Query_)(J(?:an?)?|F(?:eb?)?|M(?:ar?)?|A(?:pr?)?|J(?:un?)?|J(?:ul?)?|A(?:ug?)?|S(?:ep?)?|O(?:ct?)?|N(?:ov?)?|D(?:ec?)?)(_ason_)\d{8}(.xlsx)
Podili Vijay 20 Reputation points

2023-03-07T12:32:39.5766667+00:00

Thank you @Sonny Gillissen is is there any alternative solution on these because I'm using two triggers recurrence and when a file is created or modified under 3of the action will be works on when a file is created or modified reaming two parallel action will trigger daily 9am so if one file will upload in the share point which is related to when a file is created or modified trigger that action will be successfully triggered reaming all are failed is it possible to use the consditon action
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-07T12:47:31.4+00:00

Sorry, I don’t fully understand what you mean. Could you elaborate a bit more, please? When possible with a small drawing explaining the use case. Then I can better advise you.
Podili Vijay 20 Reputation points

2023-03-07T13:14:05.51+00:00

^(Query_)(J(?:an?)?|F(?:eb?)?|M(?:ar?)?|A(?:pr?)?|J(?:un?)?|J(?:ul?)?|A(?:ug?)?|S(?:ep?)?|O(?:ct?)?|N(?:ov?)?|D(?:ec?)?)(ason)\d{8}(.xlsx) why you give jan to dec months

Podili Vijay 20

"triggers": {

        "When_a_file_is_created_or_modified_(properties_only)": {

            "evaluatedRecurrence": {

                "frequency": "Minute",

                "interval": 3

            },

            "inputs": {

                "host": {

                    "connection": {

                        "name": "@parameters('$connections')['sharepointonline']['connectionId']"

                    }

                },

                "method": "get",

                "path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://test.sharepoint.com/teams/test'))}/tables/@{encodeURIComponent(encodeURIComponent('17d210cd-86a0-43fb-a0f6-ed148d8c3464'))}/onupdatedfileitems"

            },

            "recurrence": {

                "frequency": "Minute",

                "interval": 3

            },

            "splitOn": "@triggerBody()?['value']",

            "type": "ApiConnection"

        },

"Recurrence": {

            "recurrence": {

                "frequency": "Minute",

                "interval": 3

            },

            "type": "recurrence"

        }

    }

Podili Vijay 20 Reputation points

2023-03-07T13:48:04.5566667+00:00

Above one is the demo code which is like my requirement so I'm using two triggers when a file is created or modified and recurrence recurrence-> it will used for 1st two parallel actions those two actions will run 9am every day when a file is created or modified ->it will used for user will upload the file in randomly so only that time only related action will trigger so those paths i will pass on when a file is created or modified trigger conditions now the problem is if the file will upload the in the path only that action will excecute reaming all are failed so I want see my logic app succed whether the file is uploaded or not . @Sonny Gillissen did you understand my point.
Podili Vijay 20 Reputation points

2023-03-07T15:19:46.41+00:00

const fileName = workflowContext.actions.Compose.outputs;

const regex = new RegExp('^(Query_)(J(?:an?)?|F(?:eb?)?|M(?:ar?)?|A(?:pr?)?|J(?:un?)?|J(?:ul?)?|A(?:ug?)?|S(?:ep?)?|O(?:ct?)?|N(?:ov?)?|D(?:ec?)?)(ason)\d{8}(.xlsx)');

if(regex.test(fileName)) { return true; }

else {return false; }--->if I try to give these cose i will get an error The workflow must be associated with integration account to use the work run action 'ExecuteJavaSctiptCode' of type'JavaSctiptCode'. @Sonny Gillissen did you understand my problem?
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-08T09:38:52.9633333+00:00

For the inline code: this indeed needs binding with an Integration Account on Logic App Consumption. When using a Logic App Standard this is possible without an Integration Account.

When you would like to use a Logic App Consumption you could also introduce an Azure Function using the same RegEx to check for the file name.

The use case is still not clear to me, I'm sorry. Why would you want to trigger on file creation and recurrence on the same?
Podili Vijay 20 Reputation points

2023-03-08T14:43:24.12+00:00

Thank you for your response i had given the steps step1: we had maintained two kind of data one is a and next one is b in the share point SharePoint will have n number of paths step 2: a type of files will upload the SharePoint in 9am daily so I'm using recurrence trigger for these case we step3: b type of file don't mantain the time for these case I'm using when a file is created or modified trigger above all the steps i was excute successfully but problem is if a files trigger b files actions are failed if b files actions trigger a file action will failed so how we can overcome these case @Sonny Gillissen
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-09T10:59:28.1933333+00:00

So, basically, just so I know I'm understanding you correctly: you want a solution to make sure files are not picked up by the "when a file is created" trigger when it's supposed to be handled by the recurrence? Is that correct?
Podili Vijay 20 Reputation points

2023-03-10T03:40:49.0133333+00:00

Yes i thought will use condition but i don't know how we can implement
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-10T20:56:16.7566667+00:00
Okay, then I understand it. In my opinion there are two things here:

Why should these files not all be handled by the “when a file is created” trigger only?

When this is necessary, you can make the recurrence trigger and get files from one (or two folders) to process, and let the “when a file is created” trigger exclude these two folder paths as per the trigger condition noted before
Podili Vijay 20 Reputation points

2023-03-11T03:40:31.7033333+00:00

1.om my share point there will be have n number of paths out of i will be use 6 paths. 2. I was added the recurrence code in code view so out of 6patha 2 of the paths will place files daily at certain time reaming 4 paths will place files randomly fir these purposes will use when a file is created or modified trigger i hope i wa clarify your questions
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-14T11:20:14.6333333+00:00

Then I think excluding the file paths picked up by the recurrence trigger through the trigger conditions are indeed the best approach in your use case.
Podili Vijay 20 Reputation points

2023-03-14T15:21:34.8333333+00:00

Thank you for your response @Sonny Gillissen can you show me the implementation steps .
Podili Vijay 20 Reputation points

2023-03-18T10:22:17.6466667+00:00

Thank you @Sonny Gillissen for your help did we pass two expresions in when a file is created or modified trigger settings i was able to pass but the first expression will be trigger if it's true but second expression is not trigger even if it is true bellow is my expressions
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-18T11:58:17.0566667+00:00

It’s because you added it in two rules. If you do so, both must be true for it to fire. You can best add both in one rule within an or() function, like or(CONDITION1,CONDITION2)
Podili Vijay 20 Reputation points

2023-03-18T13:57:32.6766667+00:00

But what is the meaning of + add symbol and is it possible to check first 5 characters in file name if it match then logic app will trigger. Is it possible can we pass along the file path on trigger settings
Podili Vijay 20 Reputation points

2023-03-18T14:35:28.65+00:00

I was try to pass@or(startsWith(trigger Body()['{Fullpath}'],triggerBody()['{Name}'],'Shared Documents/new/abc/pb/delivery/',abc_bp _ query'),startsWith(triggerBody()['{Fullpath}'], triggerBody()['{Name}'],'Shared documents/new/clear/bp/','document_ data')) so l was implemented these expression for it was checking the file name along with the path .but if I upload the file in desired path logic app did not trigger @Sonny Gillissen
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-18T19:28:41.3266667+00:00

Hi James James

With the '+ Add' button you can add multiple conditions, however: all rules should return true for the trigger to fire. Please check the article below for more detailed information:

https://techcommunity.microsoft.com/t5/integrations-on-azure-blog/what-you-need-to-know-about-trigger-conditions/ba-p/2320757

So, I've made your code a bit more visual, which looks like this:

This is not working, in any way unfortunately, as it doesn't know what to do with it (therefor the trigger won't fire most probably).

Because you say you want to check the start of the filename, I think it's better to check on {FullPath} only instead of {Name}. For you are then checking if the path is something specific, as well as the start of the filename (together with the prefixed filepath). Then your code will look as follows:

or(startsWith(triggerBody()['{FullPath}'],'Shared Documents/new/abc/delivery/abc_bp_query'),startsWith(triggerBody()['{FullPath}'],'Shared Documents/new/clear/bp/document_data'))
Podili Vijay 20 Reputation points

2023-03-19T11:31:00.6266667+00:00

What abou the file name query ason Feb with 18032023.xlsx i had an idea to check first four letters these file then trigger the logic app along with above mentioned file path @Sonny Gillissen
Podili Vijay 20 Reputation points

2023-03-19T12:04:18.9433333+00:00

Some miss communication happened my exact path is Shared documents/new/clear/cp/2023/03/Nar-19/document_ data.xlsx if give give without year and month , date folder logic app did not trigger i think will pass year month and dates folders also in the expression @Sonny Gillissen and my second path file names is query ason Feb with 18032023.xlsx
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2023-03-21T07:42:14.7733333+00:00

The first could be something like this:

equals(triggerBody()['{FullPath}'],concat('Shared Documents/new/clear/co/',formatDateTime(utcNow(),'yyyy'),formatDateTime(utcNow(),'MM'),'Nar-19/document_data.xslx')

The second, however, is a bit more tricky. If the filename however is the same as the date it's created on, for example the 18th of March 2023 (as per your example) you could do something like this:

equals(triggerBody()['{FullPath}'],concat('Shared Documents/new/clear/bp/document_data/query_ason_',addToTime(utcNow(),'-1','Month','MMM'),'_',formatDateTime(utcNow(),'ddMMyyyy'),'.xslx')

If the date indeed is the same as the date it's created on you can combine above codes for your requirements, because the trigger will also fire on that day (so a file created on the 18th of March 2023 will have 18032023 in it's filename as it's trigger on the 18th of March as well).

You complete code will then look something like below:

or(equals(triggerBody()['{FullPath}'],concat('Shared Documents/new/clear/co/',formatDateTime(utcNow(),'yyyy'),formatDateTime(utcNow(),'MM'),'Nar-19/document_data.xslx'),equals(triggerBody()['{FullPath}'],concat('Shared Documents/new/clear/bp/document_data/query_ason_',addToTime(utcNow(),'-1','Month','MMM'),'_',formatDateTime(utcNow(),'ddMMyyyy'),'.xslx'))

When you cannot assume the date in the filename is the same as the date it's triggered on, you'll have to work with the 'Inline Code' action as I mentioned earlier to check for the correctly formatted filename:

Share via

How to give the two folder paths in when a file is created or modified trigger

1 answer

Your answer