First let me state that I have users modifying and creating list items using PowerApps. That may be the reason for my issue....
I have a flow that sends an email when a list item is created or modified. I have this flow looking to a field that is populated by user/group selector. I only want the email to send if the field is populated with a username, else no email.
The flow works perfect when field is populated with a username, the problem is that it still sends the email even if I update the form and leave the field blank. What's even more confusing, is that when I submit the change and remove the user through power apps, the user is now repopulated in the field. This was not happening prior to the flow. I am assuming that somehow the flow forces the last good value back in to the field?
My next thought was to trick the flow (HA!).. I created a formula that basically says if field has a value, use email. Else blank/bogus address:
User | Count |
---|---|
100 | |
37 | |
26 | |
23 | |
16 |
User | Count |
---|---|
132 | |
52 | |
48 | |
36 | |
24 |