SOLVED

[Solved] Identifier for referencing the item in a list

%3CLINGO-SUB%20id%3D%22lingo-sub-1574192%22%20slang%3D%22en-US%22%3ERe%3A%20Identifier%20for%20referencing%20the%20item%20in%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574192%22%20slang%3D%22en-US%22%3EHi%2C%20it's%20better%20to%20use%20Item.GUID%20because%20if%20we%20use%20the%20normal%20item.ID%20then%20there%20might%20be%20the%20same%20ID%20that%20is%20the%20same%20in%20both%20List%20A%20and%20List%20B%20but%20with%20the%20different%20Item.%20So%20better%20to%20use%20Item.GUID%20or%20combination%20of%20List.ID%20and%20Item.ID.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1582559%22%20slang%3D%22en-US%22%3E%5BSolved%5D%20Identifier%20for%20referencing%20the%20item%20in%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582559%22%20slang%3D%22en-US%22%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20solves%20my%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1567491%22%20slang%3D%22en-US%22%3E%5BSolved%5D%20Identifier%20for%20referencing%20the%20item%20in%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567491%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20three%20sharepoint%20lists%3A%20ListA%2C%20ListB%2C%20ListLogs.%20Every%20time%20an%20item%20of%20the%20ListA%20(or%20ListB)%20is%20modified%20I%20write%20in%20the%20ListLogs%2C%20through%20automatic%20flow%2C%20three%20information%3A%3CBR%20%2F%3E1)%20timestamp%3CBR%20%2F%3E2)%20link%20to%20ListA%20(or%20ListB)%3CBR%20%2F%3E3)%20reference%20to%20the%20item%20that%20has%20been%20modified.%3CBR%20%2F%3EThen%20I%20run%20statistics%20through%20PowerBI.%3CBR%20%2F%3EFields%202)%20and%203)%20are%20used%20to%20reference%20items%20that%20have%20been%20changed.%20What%20is%20more%20correct%20to%20use%20to%20reference%20the%20single%20item%3F%20Should%20you%20use%20the%20List.ID%20or%20List.Item.GUID%20field%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1567491%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi.

 

I have three sharepoint lists: ListA, ListB, ListLogs. Every time an item of the ListA (or ListB) is modified I write in the ListLogs, through automatic flow, three information:
1) timestamp
2) link to ListA (or ListB)
3) reference to the item that has been modified.
Then I run statistics through PowerBI.
Fields 2) and 3) are used to reference items that have been changed. What is more correct to use to reference the single item? Should you use the List.ID or List.Item.GUID field?

 

Thanks

2 Replies
Best Response confirmed by ms-jaft (New Contributor)
Solution
Hi, it's better to use Item.GUID because if we use the normal item.ID then there might be the same ID that is the same in both List A and List B but with the different Item. So better to use Item.GUID or combination of List.ID and Item.ID.

Thanks!

 

It solves my problem.