web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Unique Identifier Issue
Power Automate
Answered

Unique Identifier Issue

(0) ShareShare
ReportReport
Posted on by 6

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

spikeharvey_0-1718284782064.png

I then created the following flow

spikeharvey_1-1718284801299.png

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

spikeharvey_2-1718284819352.png

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

spikeharvey_3-1718284838847.png

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

spikeharvey_4-1718284859977.pngspikeharvey_5-1718284871511.png

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.

Categories:
I have the same question (0)
  • Manish Solanki Profile Picture
    15,167 Moderator on at

    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 Profile Picture
    6 on at

    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? 

     

    spikeharvey_1-1718286695060.png

     

     

    spikeharvey_0-1718286671326.png

     

  • Verified answer
    Manish Solanki Profile Picture
    15,167 Moderator on at

    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 Profile Picture
    6 on at

    That worked, Thanks heaps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard