I have leads coming in containing text names for countries from a web form that uses something akin to an option set, the lead arrives with the country name filled in a text column. In Lead, we use a custom table for country for reporting purposes and have a country lookup column to show it on the Lead form.
I want a flow to read the text name, look up the name column in the country table, then update the lead country look up column with the matched country.
I have set up a trigger which correctly pulls the effected lead when it is created (or updated).
I have a List Row action which allows me to search and find the country using the text column from the trigger.
I have set the Top Row to 1, it is correctly pulling one country row when I test.
I then am trying to update the original lead row, I know the preceding List Row action will create an Apply to All if I just select the GUID dynamically even though I limited the action to just one item to return. I have read elsewhere that the right process is to use a "first" expression to update my lookup field when updating the lead record. But I keep getting errors, the other examples of expressions I have seen here don't work. Can anyone help?
My country table GUID column name is c9_countryid
Here is my flow and the expression I can't fathom!
The first two actions pull data correctly,
The third action is updating the right row, I tested by adding some text to the notes fields and the whole flow reacts as expected and updates the original lead row.
My challenge is extracting the country GUID from the List Row action and then updating it in the third action.
To update the look up field in the Lead, I have this expression
'List_country' is my second action.
c9_countryid is my primary ID for the country table.
When I view the failed run i get this error message which suggest the expression is not right for the file type?
Can anyone suggest what is the correct expression to use please?