Hi All,
I am in need of some help please. I have a csv that is sent to a recipient account as attachment. The attachment is then sent to SharePoint document Library. This triggers the parsing of the data. From the parsed data I then create a new item in a SharePoint list.
This is all working fine and in fact the first name, surname, date are all populated. Unfortunately the email address is not. This column remains blank.
I use the following expression string(item()?['Email'])
As you can see the email is present in parsed JSON output but not in the create item outputs.
CSV Headers are: Unique Id,First Name,Surname,End Date,Last Working Date,Email
Can anyone suggest where I may be going wrong ?
MANY THANKS
