@ppei
Ok, I think I have something that works, and is surprisingly elegant (for me) 🙂
The first thing I did was add a filter to the Get Items so that I'm filtering out anything that has a null in that field to begin with. This negates the need for a condition and requires only the simplest of OData - FieldName ne null - The FieldName is RelatedDepartment field and 'ne' is "Not Equal to" and "null" is essentially blank. See below:
Next, I added a condition to check if the array was empty. Again, this is a simple expression that returns "True" if the array is empty, and "False" if there's stuff in it. Pieter Veenstra has a cool article on Arrays in Flow. The expression looks like this:
empty(body('Get_items')) which tells Flow to look in the output of Get items for an empty array...
If it is True, the array is blank and we probably don't want to do anything. If it's False, then there's something there and we want to send the email. Here's the whole Flow:
I still have one more trick if this one doesn't solve it for you...this one just seemed to be the simplest and most stable.
Let me know if that helps.
-Ed-
If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
