Unanswered

SharePoint Item Lookup

(0) Share

Report

Posted on by WiggityZwiggity

358

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?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
WiggityZwiggity 358 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
WiggityZwiggity 358 on at

Like (0)

Report

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"

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
WiggityZwiggity 358 on at

Like (0)

Report

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 "-"?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No