SharePoint Flow - modify list item or create new if doesn't exist

Question

As you can see in the picture below, initally, I am using the trigger 'When file is created or modified (properties only)". I need a condition to tell whether a file is being created up merely updated. If it is new, then it will use the 'Yes' section and create a new item. If a file is just being modified, then it will update the list item. But, I do not know how to set up the condition to do this?

Thanks!

Answer 1

Would Created != Modified work? Something like this:

@not(equals(triggerBody()?['Created'], triggerBody()?['Modified']))

"Yes" in this scenario would be modified (its a not). You can just adjust accordingly.

Answer 2

In my SharePoint online environment, I can select “When a new file is added in SharePoint, complete the custom action”. Then you can trigger the flow only when a file is created.

You also could create workflow for the document library to trigger your actions in SharePoint designer 2013. You could create two workflows. One workflow can be triggered when a file is created. And the other workflow can be triggered when a file is updated.

In the workflow settings, in the start options, you can select “Start workflow automatically when an item is created” in one workflow. Then the workflow will be triggered when a file is created.

And you can select “Start workflow automatically when an item is changed” in the other workflow.

The two workflows will be triggered by different conditions.

More reference:

Creating a workflow by using SharePoint Designer 2013 and the SharePoint Workflow platform.

https://docs.microsoft.com/en-us/sharepoint/dev/general-development/creating-a-workflow-by-using-sharepoint-designer-and-the-sharepoint-wo