Trigger a flow when file is modified in the a sharepoint folder

(0) Share

Report

Posted on by RichCoutinho

Hi all,

I am stuck and i do not know how to move on.

I have a SharePoint folder which i have several excel files, which is manually updated daily. And those files are used to as a source for a PowerBi dashboard, so I have created a flow to refresh a PowerBi when a file is modified in the folder, which is working greatly so far.

This flow has as trigger When a file is created or modified (properties only) which i have added to the setting on the trigger condition the expression : @equals(triggerOutputs()?['body/{FilenameWithExtension}'], 'File_name.xlsx')

So when the specific file is modified it performs the powerbi dataset refresh. However now i need to put as condition when 2 specific files are modified then perfoms the dataset refresh.

I have tried to add on the condition the line 1: @equals(triggerOutputs()?['body/{FilenameWithExtension}'], 'File_name.xlsx') and line 2 : @equals(triggerOutputs()?['body/{FilenameWithExtension}'], 'File_name2.xlsx') however when i modify the those files the flow doesn't trigger.

I also tried @And(equals(triggerOutputs()?['body/{FilenameWithExtension}'], 'File_name.xlsx'), equals(triggerOutputs()?['body/{FilenameWithExtension}'], 'File_name2.xlsx') ) which doesn't work either.

I do not know if theres' a way to trigerr only if those 2 specific files has been modified.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Geeks_D 1,169 on at

Like (0)

Report

Hello
I think your condition here is the issues
And will check if the two files are modified
Or will check if any of the two files are modified
The chance of the two file been modified same trigger time is zero to non
So the Or statement is better suited

Was this reply helpful? Yes No
RichCoutinho 2 on at

Like (0)

Report

Hi @Geeks_D thanks for the info...the OR statement doesn't work for me as it will check if one or another has been updated, and i need to trigger it if the 2 files has been modified, if only one of them has been updated, it should not trigger.

I do not know if i can check if the both files has been updated in the last 15min, as they take last than 10 min to be updated between them, generally it takes seconds of difference.

Was this reply helpful? Yes No