Power Platform Community Forum Thread Details

I am trying to use a REGEX formula to validate the expected format of a reference ID number.

My Reference ID is coming from another table in Dataverse for a specific record that comes from a When a row is added or modified trigger:

triggerOutputs()?['body/abc_refID']

My REGEX formula is being pulled from a specific Dataverse column on the account table for a given supplier from a Get a row by ID action: ('Get_a_row_by_ID_Account')?['body/abc_refidvalidation']

This is the REGEX formula I am using to validate:

I am setting up a compose action followed by a condition that will check if the output is true.

Here is the 'Compose RefID is Valid' expression:

@{not(empty(match(triggerOutputs()?['body/abc_refID'], outputs('Get_a_row_by_ID_Account')?['body/abc_refidvalidation'])))}

The following condition step is: outputs('Compose_RefID_is_Valid') is equal to true

Here is the error I get at the :

Unable to process template language expressions in action 'Compose_RefID_is_Valid' inputs at line '0' and column '0': 'The template function 'match' is not defined or not valid.'.

ChatGPT sats the match function is not compatible with Power Automate, but other sources online indicate it is. Can I get a definitive answer on this topic and possibly a suggestion on how to dynamically validate this field based on the unique account expectations?

Categories:

Building flows