I have the same problem as the author.
And i create an apps as your solution.
My SharePoint List Name: Shift Turn Registration
Share Point Column Name: TeamMember
But apps pop up an alert like this:
My Formula like this:
Although i created an list and apps same with yours, it also have the same alert.
Could u please help?
Thank u sooooooo much!