How to loop on each column in sharepoint list?

Help Studio
, , , , , ,
1

Hello experts!

I have a “XYZList” on sharepoint site, i want to loop on column “Date”. if date matched i wanna push it to queue.

How to do this ? any idea ?

1 Like
2

Hi @RobotUi ,

Use For Each List Item Activity to loop through all the items in the SharePoint and configure the ColumnsToRetrieve Property to get the required columns from List and after that use IF condition to match the same.

CurrentItem(“Date”).ToString

1 Like
3

Hi @RobotUi ,

Please refer to the screenshot.

  1. Configure the Sharepoint connection, Columns to retrieve, and Filter condition.
    Capture

  2. Sample Filter Condition
    Capture2

  3. Use Add Queue Item to add data into Queue.
    Capture3

1 Like
4

Ok till here i got to know this.

Now i want to add attachment to "Attachment"column in same list. That attchment maybe “.xls” file

1 Like
5

Hi @RobotUi ,

As per my knowledge, there is no activity available to upload files into the SharePoint list to "Attachment"column. But you can create Create Document liberary in the share point and use Activities - Upload File (uipath.com) activity to Upload the files into the sharepoint and you can pass that link into SharePoint list Item column.

For more details please refer following posts.
Add File Attachment to SharePoint List Item - Help / Something Else - UiPath Community Forum
How do I upload Sharepoint List item File - Help / Activities - UiPath Community Forum

1 Like
6

Can i change the value of column “Name” ?

If so how ?

1 Like
7

Hi @RobotUi ,

I think from UiPath we dont have any activity to modify the Column Name of Sharepoint List.

Please refer to the following document for the list of activities available in UiPath and their capabilities.
Activities - SharePoint Lists activities (uipath.com)

image
image918×374 30.1 KB

1 Like
8

I am trying to retrieve value from column “Transaction Date” from sharepoint list using get List items activity, it provides output as DataTable. While looping thorugh the columns i found that , it is retriving the column name which is not present on sharepoint list item.

What may be the problem ?

I am trying to get the item from list and update the attachment.

1 Like
9

@Anil_G . . . . . . …

10

@RobotUi

Get items will get all columns…including the hidden columns that are not present on ui…so you might see some extra columns as well…you can check the list settings for full list of columns

And coming to changing the name…I dont think so you can …using any…

There is an api way to foint…but for that you need to follow a separate authentication and all

Cheers

11

My concern is to add a attachment in a list item.
Lets say i have 5 columns (including attachment) in SharePoint list and i want to add the attachment file “.xlsx” in attachment column of sharepoint.

12

@RobotUi

I guess this is taken in another post already…there is no direct activity available to send an attachment currently…

Cheers

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.