Update List Item Activity Issue when data values have lookup field to another list, that presents as a hyperlink

Help Activities
1

I know this is an older thread, but I am facing an issue utilizing the update list item activity. I don’t have any hyperlinked data columns, but I do have a lookup field to another list, that presents as a hyperlink (see screenshot). Is this the source of my issues. If so is there a way to modify the update list item request so it is successful? appreciate your help

image
image706×118 4.93 KB

2

Hello @david.rya.goderre1

  1. Retrieve the correct lookup field value from the lookup list.
  2. Update the lookup field using plain text instead of a hyperlink.
  3. Check SharePoint column settings for the lookup field.
  4. Ensure you’re using the correct identifier when updating the lookup field.
  5. Test updating the lookup field with a plain text value.

Thanks & Cheers!!!

3

After some more narrowed research I found out that the lookup field was fine. It is actually the choice field that I have that is causing the issue. Do you know a way to resolve the issue of updating a list item with a choice field that allow multiple choice selected? Again I appreciate your response and help!

4

@david.rya.goderre1

  1. Get List Item:
    Input: List Item ID, Site URL, List Name

  2. Assign activity:
    existingChoices = YourListItems(“MultipleChoices”).ToString.Split({“;”}, StringSplitOptions.RemoveEmptyEntries).ToList()

  3. Modify existingChoices as needed, e.g., add or remove choices

  4. Assign activity:
    updatedChoices = String.Join("; ", existingChoices)

  5. Update List Item:
    Input: List Item ID, Site URL, List Name
    Fields: “MultipleChoices” = updatedChoices

5

Note that there is a limitation with the Official SharePoint UiPath activities via the O365 library when the sharepoint list item contains a populated URL field value.

This is extremely problematic if organizations have a strict feed policy and are expected only to use Official libraries. I strongly encourage UiPath to fix its official O365 activities to enable all capabilities of editing SharePoint List Items through its activities.

For such commonly used enterprise apps, we can’t rely on marketplace or even UiPath team-developed libraries (or at least make them official at this point)