if Boolean returns true then replace "Applicant" with ""
Finally update "Applicant" member within the lookup table to add record "Miss Nikita Collier"
Screen shot of proposed automation flow below:
I would like to know whether it is possible to loop through the field members of a lookup table which would enable me to "SeekString" as per automation flow and if possible how I would update the correct field member second highlighted mark.
Any alternative solutions would be much appreciated if this can be achieved in a different way.
Would you be more specific about what you are doing? You can see the columns as outputs when you call GetRecord. Are you asking to loop through all of the records, or to just get a list of the column headers? I ask because the latter doesn't seem very useful since you'd know the columns already in your setup of the lookup table.
Here's a method you might use to iterate the column names. I don't think you need to do that though as your column names are going to be static by the very nature of a lookup table (i.e. it can't change it's columns at runtime). It might just be easier to use a Switch to handle specific ones from your HTML table and update the corresponding field in your lookup table. If you want to iterate them though, here's a method that will work. The key is to use the GetTable method from the LookupTable as that returns the underlying DataTable object. From there, you can access the Columns property to get to the collection of columns which you can iterate to get the ColumnName of each one.