Hello everybody,
I am currently trying to pull data from a SharePoint List. To be exact I want to retrieve 3 columns and their information. I dont know how to visualise the Data now after getting it. My goal is to transfer it into another program. Does someone know how I can get the information for example about “ProjectNr”?
Thank you but I dont think it works. I just want to get the information. what Activity should i use?
just use a log message to see the value inside for loop
ListItem.Fields.Where(function(x) x.DisplayName.Equals("Display Name of Field"))(0).Value - change display name based on value you need
you need to try first before you say it does not work
cheers
So basically The ListItem is the column i retrieve inside the “For each List Item” Activity. As far as i understand. Before that i use Get List info and Get list items. So ListItem should be the column called “ProjectNr”
Cheers
Yes, you’re correct! The ListItem refers to the individual list item (or row) retrieved inside the For Each List Item activity after using Get List Items to fetch the data.
For example, when you loop through each ListItem in the For Each activity, you can access the “ProjectNr” field by using:
ListItem(“ProjectNr”).ToString
This directly retrieves the value of the “ProjectNr” column for each list item. Make sure that the column name (“ProjectNr”) matches exactly with the internal name of the field in your SharePoint list.
Happy Automation
Thank you very much Sir,
This is exactly what worked for me !
Do you have any idea why it works in the scope of this activity but later on it returns nothing? (The variable is used in the global scope already)
Cheers
@Charly-Moreno Great
It likely works within the activity scope because the variable is properly assigned there, but later returns nothing due to either being overwritten or not properly retained outside the scope.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
