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?
20
Share
Report
All responses (
Answers (
