Unique Identifier Issue

[spikeharvey]

Newbie here trying to educate myself!

Background: I have two (for now) projects each with their own project site on SharePoint. In each site I have created a Risk log (child) in a SharePoint list. In addition to this I have a portfolio SharePoint site with a Master Risk log (I have copied the list structure across all sites so they mirror the same columns/fields). I want to sync child lists to the master so there is a single reporting list for the whole portfolio.

Scenario: When an item is created in one of the project (child) lists it creates an item in the master and if the entry (list item) is updated in the child list it updates the entry in the master using a unique identifyer e.g FMR001.

In order to be able to identify the item ('if it does not exist = create' or 'if does exist = update') I created a field called MasterID

I then created the following flow

and in the Get Items action the filter query was the dynamic field MasterID eq MasterID.

The condition was then length(outputs('Get_items')?['body/value']) is equal to 0

I then have a true or false branch if =0 create if=1 update.

I tested the flow and this works perfectly with just a number in the MasterID field however this becomes an issue when I introduce letters into the MasterID e.g. FMR001

I need to do this as I have multiple child lists (one for each project) and cant copy the same identifier e.g. 1, 2, 3 because this would then overwrite (update) entries from other child lists.

When introducing the letters into the MasterID the flow fails with the following message

The expression "CVOR001eq MasterID" is not valid. Creating query failed.
clientRequestId: c6f65673-b3ac-4d9d-9fb8-689ed38e7675
serviceRequestId: c6f65673-b3ac-4d9d-9fb8-689ed38e7675

I cant understand why with the introduction of letters it now appears to have an issue, I know this is down to understanding so looking for some help/explanations please.

[ManishSolanki]

Hi @spikeharvey 

Pls use the below pattern for filter query:

<Internal ColumnName> eq '<dynamic content>'

For eg:

MasterID eq 'CVOR001'

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[spikeharvey]

That doesnt seem to work either, I switched the query around but I cant use CVOR001 as this is only valid for one entry, there will be multiple entries, my understanding was that if it matches a unique identifier it then actions the true/false but if i use CVOR001 in the query then it's always going to check for that, is that right? 

[ManishSolanki · Accepted solution]

Hi @spikeharvey 

You missed the single quotes:

<Internal ColumnName> eq '<dynamic content>'

For eg:

MasterID eq 'CVOR001'

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[spikeharvey]

That worked, Thanks heaps.