Trying to get an automation going where if the text output of a field (i.e Prop1Text) from a formula field (Prop1) that is parsing the input (Property) matches the text in a different view, the “status” field is updated to my desired option.
I had an issue with my first test because when the request for multiple properties came in, the “prop” field had all of them in a single string and that failed the previous automation find record if “Property”
in master list is “Prop” Text then update. Currently i am getting the “invalid filter on Property field” error when I try to do a find record action
I had read that formula fields cause issues during lookup automation (not sure entirely) so I had it copy the text from the formula field “Prop1” into a single line field “Prop1Text” by another automation. That is working perfectly fine, but i am stuck at trying to get the matching record ID to update that status of that specific record