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.
