thanks! filter array is a great way to get the correct expression. now I've got to check my flows as I was under the impression that they were operating on an Or basis!
Excellent video, best explanation of trigger conditions, and using filter to build condition is great, easier then using compose as suggested in lots of other videos
Thank you so much for this video. I've been a long time SPD/Workflow/Infopath user but now i'm trying to catch up on the Power Platform. I've been working days trying to get the update item loop issue worked out and this video finally showed the best way to create a trigger expression that actually works. Of course I could have done this in five minutes with SharePoint Designer and the 2013 Workflow engine, but hey, let's embrace the new technology.. LOL
very elegant solution! I would also like to check multiple required fields if any of them are null. is it possible to incorporate it in the trigger conditions?
hello I would like to know how we can define a trigger condition based on the attachment name and extension. for instance I want my flow run only if the attachment is an Excel file which name contains specific letters (**RMa*.xlsx). Thank you for your videos and your support.
This will only work where there is a single attachment, as the attachments name is an array. You can query the first file name as follows: @and(contains(first(triggerOutputs()?['body/attachments'])?['name'],'RMa'),endsWith(first(triggerOutputs()?['body/attachments'])?['name'],'.xlsx'))
hello, very impressed by your fast and accurate feedback ! Your solution works perfectly. Thank you again and have a good day. I will be waiting for your next video !
Damien, thank you - this is my first flow ever and because of you I succeeded. I have a question thought - how can I convert .xlsb to .xlsx file with Power Automate flow?
I'm trying to use the trigger condition @not(equals(triggerOutputs()?['body/Editor/Email'], 'user@email.com')) - this is what I received when using the filter array. However I get the error "Cannot read properties of undefined (reading 'properties') - what am I missing? Thanks!
@@DamoBird365 When an items or a file is modified. I also tried when a file is created or modified . Can this be done on the Site Pages library with Approvals on? I want to have the flow run only when a page is added or updated by someone other than a specific user. Thank you for your time!
Thankyou for helping with your examples. Using filter and then advance option will going to help in all cases.
Thanks Again!
Thanks. Nice tutorial on the Filter Array to generate Trigger Conditions.
Thanks Stephan.
thanks! filter array is a great way to get the correct expression. now I've got to check my flows as I was under the impression that they were operating on an Or basis!
Life-saver! Thank you for this.
Excellent video, best explanation of trigger conditions, and using filter to build condition is great, easier then using compose as suggested in lots of other videos
Brilliant! thank you so much
You gave me a solid solution to my problem. Thanks 😊
Thank you so much for this video. I've been a long time SPD/Workflow/Infopath user but now i'm trying to catch up on the Power Platform. I've been working days trying to get the update item loop issue worked out and this video finally showed the best way to create a trigger expression that actually works. Of course I could have done this in five minutes with SharePoint Designer and the 2013 Workflow engine, but hey, let's embrace the new technology.. LOL
Great video, cheers 👍
useful ， sincerely。 thank you
very elegant solution! I would also like to check multiple required fields if any of them are null. is it possible to incorporate it in the trigger conditions?
You can use and( , ) learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#and
hello I would like to know how we can define a trigger condition based on the attachment name and extension. for instance I want my flow run only if the attachment is an Excel file which name contains specific letters (**RMa*.xlsx). Thank you for your videos and your
support.
This will only work where there is a single attachment, as the attachments name is an array. You can query the first file name as follows:
@and(contains(first(triggerOutputs()?['body/attachments'])?['name'],'RMa'),endsWith(first(triggerOutputs()?['body/attachments'])?['name'],'.xlsx'))
It's worth noting that string comparison is case sensitive, you might need to explore tolower() or toupper(). Please give it a try and test test test
hello, very impressed by your fast and accurate feedback ! Your solution works perfectly. Thank you again and have a good day. I will be waiting for your next video !
@@jeanlouisterranova2042 if you have any use cases that I could cover in a video, feel free to email me ideas@damobird365.com
Damien, thank you - this is my first flow ever and because of you I succeeded. I have a question thought - how can I convert .xlsb to .xlsx file with Power Automate flow?
I’ve not found a way of converting x to b or b to x at the moment. Well done on building your first flow! Keep it up and enjoy.
I'm trying to use the trigger condition @not(equals(triggerOutputs()?['body/Editor/Email'], 'user@email.com')) - this is what I received when using the filter array. However I get the error "Cannot read properties of undefined (reading 'properties') - what am I missing? Thanks!
What’s your trigger?
@@DamoBird365 When an items or a file is modified. I also tried when a file is created or modified . Can this be done on the Site Pages library with Approvals on? I want to have the flow run only when a page is added or updated by someone other than a specific user.
Thank you for your time!