Re: How to send survey only once per day/week for several resolved cases?
Hello! I have tried the solution described in the article above. However I have encountered the following problem:
I have created a scheduled flow which runs once a day. I use the function List rows, to get all the cases closed the last 24 hours. Then use the function Select to get the customerid value and then the compose function to get the unique values of customers. It looks like that:
However the field "customer" in the Case table is look up to two tables Account/ Contact. I am trying to apply a condition to Customer type = Accounts. If yes, to get the account info ( email) , if not to get the contact info ( email)
It looks like this:
When I test the flow, the condition customer type eq accounts always returns false. It has to be true. What confuses is me is that I can not see the field customer type in the columns of the table Cases. Not in the Choices either. I tried accounts, account, integer ( 1, 2). Nothing seems to work. Can somebody have a clue what might be the reason and what to do? Thanks in advance for your help.
