Unanswered

Empty List Column

(0) Share

Report

Posted on by DDM

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Caspar_Rubin 831 on at

Like (0)

Report

Re: Empty List Column

Hey,

don't you need to use the "Email\r" value instead of only "Email" in your Expression?

string(item()?['Email\r'])

If that doesn't work, maybe you can parse it cleanly so you don't have the \r in there...

cheers

Was this reply helpful? Yes No
DDM 79 on at

Like (0)

Report

Re: Empty List Column

Thanks for the suggestion. It wasn't the solution, unfortunately.
I don't even know where the \r is coming from. Its a carriage return right ? So i guess its getting picked up from the CSV itself but it isn't in my parsed JSON.

Was this reply helpful? Yes No