Unanswered

SharePoint Item Lookup

(0) Share

Report

Posted on by WiggityZwiggity

356

What is the best method for finding and updating an item in SharePoint where you know the value of a unique field but not necessarily the ID or item GUID (given that is the only way to identify a sharepoint item)

Would you use the SharePoint getitems and an ODATA filter that was: "$filter": Field_X0020_Name eq 'uniquevalue' and then use the ID from that query?

All responses (6)

Answers (0)

abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: SharePoint Item Lookup

Hi,

Couple of options:

(1)
You need the original id to store in a custom sql table or Excel Sheet (one drive). Write a function in SQL table column or Excel sheet to convert into "-". This way you got both formats are stored. Then use this intermediate storage to use your query filer.

(2)
Host a custom Web API to take the GUID as input and convert into the other format (return value)

Good luck
WiggityZwiggity 356 on at

Like (0)

Report

Re: SharePoint Item Lookup

I think I identified why this isn't working. I am using an Exchange calendar GUID from a calendar item modification action in a flow that I then wanted to use as a variable to query a SharePoint list for an item that contains the same Exchange GUID (that is written to that item based on the modification of that SharePoint item that triggers a Nintex Workflow to create a Calendar Item through an Office 365 exchange connector. The difference is how those GUID's are represented:

AAMkADJiZThiNzAwLTU5MjktNDg4ZS1hZGNkLTVlMDAwMWRjMzlhMABGAAAAAAB88UgFY3peSI8P6uZROIsmBwDIj5a6gWq_S5jc3-Iz5-wBAAAAAAENAADIj5a6gWq_S5jc3-Iz5-wBAAFMQnNVAAA= (From the Flow Modification Action)

AAMkADJiZThiNzAwLTU5MjktNDg4ZS1hZGNkLTVlMDAwMWRjMzlhMABGAAAAAAB88UgFY3peSI8P6uZROIsmBwDIj5a6gWq+S5jc3/Iz5/wBAAAAAAENAADIj5a6gWq+S5jc3/Iz5/wBAAFMQnNVAAA= (From the Nintex Action)

How can I get these two in sync - is there a way to parse the string and replace the "/" character with "-"?
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: SharePoint Item Lookup

Try the filter quey without the equal (=) sign from the begining. If that doesn't work try removing the single quotes of the id.

Thanks
WiggityZwiggity 356 on at

Like (0)

Report

Re: SharePoint Item Lookup

So 2 methods I have tried:

One using a filter on the returned array which does not work, or 2 using an ODATA filter on the get items action (which I asume my syntax is incorrect, I've tried a few things"
WiggityZwiggity 356 on at

Like (0)

Report

Re: SharePoint Item Lookup

Got it - thats what I assume, when I look at the query results of inputting a query into the ODATA filter field I am confused on the correct syntax - was my previous post correct?
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: SharePoint Item Lookup

Hi,

Yes to update the item you need to set the ID. If you don't have the ID then you need to use the Get Items ODATA Filter and use the ID.

Thanks

Ajith