I'm working on a flow that sends out emails monthly. The flow works, but I get an error each month saying the flow did not work since not every row has an email associated. I've been reading up that you can use either the Filter Query or Filter Array, but I can't seem to figure out how it works. I have two separate columns that would have an email in it so I need to filter out two separate columns/rows.
The way I have the flow set up is once a month, it pulls the emails from excel, and the condition looks to see if a specific column has an x in there. (This is to not send an email out to previous month's group of emails)
If there is an X, it won't send, if blank, it goes through the two specific email rows, then sends an email. finally, it then updates that one column and places an x there to not send to this group the following month.
Some rows don't have emails associated so not only do I get an error saying the flow didn't work, even though it did. The flow also doesn't update that column to put an x so that we skip it for next month.
