Forum Discussion

AaronB's avatar
AaronB
Qrew Trainee
5 days ago

Sharepoint Channel - how do I update field/column in Sharepoint?

I have a pipeline that successfully uploads a file to Sharepoint (i.e., create a new list item in Sharepoint).

I also want to place data into a field/column of that same Sharepoint record, but am failing to make this happen.  I've tried a couple different approaches without any success.   

Any tips on making this happen will be appreciated.

I can provide more detailed screenshots if necessary but here are some to start.

Thanks in advance.....Aaron

Method 1: 

 

Method 2:

When the error says at least 1 field must be set, and to specify the field to be updated, I can't see where to do that

 

Pipelines

2 Replies

  • Mez's avatar
    Mez
    Qrew Captain
    2 days ago

    I couldn't get the fetch or look up an item to work for me after I uploaded a file (just as your workflow shows here), and at the same time I was also using the ms graph api to verify/validate the name or id of the file. 

    I ended up using the Search for an Item option using the Search.FileLeafRef == Upload.Name, and I set the limit to 1. I also ran into an issue with trying to use the Date as an additional qualifier, so I resorted to just the Date value for Created at.

    Within your update item step, you should now see the fields to update option.