Working with File Properties in SharePoint library

[jakeandsnake]

Background:

I'm building a ticketing system, it requires users to raise a ticket with an attachment files, which will be saved as attachment in a sharepoint list(Copy 1) and save as a file(Copy 2) in a sharepoint folder. In order for me to link the copy 1 and copy 2, I've added a customized file property in the sharepoint folder called uniqueID, also created a column in the sharepoint list.

Workflow:

1. When users raised a new ticket, my flow A will auto assign a unique ID for the ticket and store in sharepoint list, also will update the file property in sharepoint folder. 

2. My flow B will list down the files in that folder and get the file properties, then will use this file property to filter items in sharepoint list (put as a filter query), and do some auto updates like status, etc.

Issue:

The flows have been run smoothly without any issue for a quite long time, but last week users feedback two tickets doesn't update at all, the rest no issue. I found that for those two tickets, the unique ID I get from Flow B is totally different from the one in Flow A. I was suspecting the issue might come from sharepoint side, does anyone know what's going on here? 

Thanks~ 

[annajhaveri]

@jakeandsnake it doesnt look like issue with SharePoint, it could be a bug in flow somewhere. Can you share screenshot of both of your flows, and flow runs of the ones that are failing to further investigate the issue?

[jakeandsnake]

Thanks @annajhaveri , I believe it's not a bug in the flow because it actually runs for 4 months without any issue. This issue just came up recently only and two out of thousands run have this issue. 

[David_MA]

How are you generating your unique ID and associating it between the two lists?

[jakeandsnake]

I'm using Power App as front end, and whenever a user submit a ticket, there is a unique ID created by using GUID() in power app linked with this particular ticket. On the backend, Power Automate will pass this unique ID to the SharePoint list for the Copy 1 and also update the same unique ID to the Sharepoint Folder as field property for Copy 2. 

So in my Flow B, I'm using the unique ID of Copy 2 to filter the SharePoint List, then only found out the unique ID is totally different from the original one.

[David_MA]

It sounds like what you are doing should work. However, I don't have any insight why all of a sudden this method is now not working. Hopefully, someone else will have encountered this.

When I do what you are doing, I usually use the internal ID column from list 1 and populate that into list 2 in a field named something like RelatedItemID. This way it is not randomly generating a unique ID and it makes it easy to compare the ID from list 1 with list 2 for debugging.

[jakeandsnake]

Thanks @David_MA , ya, I realized that internal ID column might make things easier after my whole solution completed. lol. Anyway, let me give it a try and see how it goes first. Thanks again ~