Triggering Refresh

(0) Share

Report

Posted on by smpa01

148

@mahoneypat @mahoneypat2 @lbendlin

My end goal is to trigger a refresh of Power BI dataset upon modification of relevant files (data sources only).

I managed to build a flow which is currently doing the job.

But this site

contains files (e.g. src1.xlsx, src2.xlsx, src3.xlsx, src4.xlsx)

beyond data sources (e.g. src1.xlsx, src3.xlsx) required for this particular power bi data set.

Hence, the following flow is triggering refresh upon modification happening to any files whatsoever. How can I make this flow trigger bound to only any modification to src1.xlsx or src3.xlsx

Thank you in advance.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

shaboo 65 on at

Like (0)

Report

Hiya,

If you are triggering on modification on folder it's not possible to limit on trigger step, however, if you can add a next step get the SharePoint list (folder list) then add a condition if the filename = "Trigger File Name" then add your steps to on positive route so if the file name is different it just ignores.

Simply check the condition after trigger to make sure file name = your expected file if not ignore.

Hope this will help on conceptually.

Thanks
Sandeep

Was this reply helpful? Yes No
smpa01 148 on at

Like (0)

Report

@Shaboo992thanks for looking into it.

I am not actively pursuing PA unless I have a Power BI utility for it. Hence, I am not sure what are you suggesting here.

Does the following match to what you are suggesting

Also, your suggestion if you can add a next step get the SharePoint list (folder list) then add a condition if the filename = "Trigger File Name" will always return TRUE (I think), cause the file will always exist there. How do I make sure that the Dataset refresh is only triggered due to only modification of dependent excel only?

One way to do that would be to put separate files in separate folder, Like src1.xlsx goes src1 Folder, src2.xlsx goes to src2 Folder and then create separate flow for each dependent folder.
But I currently have all dependent and non-dependent excel within a single folder called SRC Data and I can't really move the non-dependent excel to other folders cause they have dependency to other BI applications.

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (1)

Report

Hi @smpa01

You can restrict the flow to be triggered only when the file name src3.xlsx or src1.xlsx is modified by setting the TriggerCondition.

@or(equals(triggerOutputs()?['body/{FilenameWithExtension}'],'src3.xlsx'),equals(triggerOutputs()?['body/{FilenameWithExtension}'],'src1.xlsx'))

Best Regards,

Levi

Was this reply helpful? Yes No
smpa01 148 on at

Like (0)

Report
@v-liwei-msft many thanks for this. I will check and let you know.

BTW can you please tell me which language is this
@or(equals(triggerOutputs()?['body/{FilenameWithExtension}'],'src3.xlsx'),equals(triggerOutputs()?['body/{FilenameWithExtension}'],'src1.xlsx'))
and where can I find more of this (documentation)

Was this reply helpful? Yes No
v-liwei-msft on at

Like (1)

Report

Hi @smpa01

I think this link will help you:

What you need to know about trigger conditions? - Microsoft Community Hub

Power Automate Trigger Conditions made EASY - Power Platform Community (microsoft.com)

Best Regards,

Levi

Was this reply helpful? Yes No
smpa01 148 on at

Like (0)

Report
@v-liwei-msft Thanks for this.

I was wondering, if it is possible at all to assign the data source in a variable and utilize the variable inside the trigger condition, more like following. Is it possible?
var sourceFirst = "src1.xlsx"; var sourceSecond = "src3.xlsx"; @or(equals(triggerOutputs()?['body/{FilenameWithExtension}'],sourceSecond),equals(triggerOutputs()?['body/{FilenameWithExtension}'],sourceFirst))

Was this reply helpful? Yes No
v-liwei-msft on at

Like (1)

Report

Hi @smpa01

This is not possible in triggerCondition.
If you want to do this, please use the condition action.

Best Regards,

Levi

Was this reply helpful? Yes No