How to use a "contains" similar function with Power FX within Power Automate Desktop

(0) Share

Report

Posted on by sebastianslz1

I need to perform a validation with Power FX within Power Automate Desktop that verifies if the variable "LinePDF" contains a value such as "Issue Date" and then assigns that value to a new variable called "Date"

I've been looking through the functions that Power FX brings but there is none like "Contains".

So far I have tried with the "StartsWith" function but I get the following error:

Invalid argument type (Record). Expecting a Text value instead. The function 'StartsWith' has some invalid arguments.

The code I have tried so far is the following:

It's important to note that I have Power FX enabled.

If you have any suggestions or would like to tell me what I am doing wrong, I would appreciate it.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Mark Nanneman 991 Moderator on at

Like (1)

Report
Copy link

Link copied!

You should have a Contains operator as an option for your If statement. If you don't see it, perhaps try updating PAD?

You can also try using "Parse Text". You can search for string or use a RegEx expression. It outputs a position number.

If no text is found it outputs -1, so you can have a condition check for the "Position" output being greater than -1

Was this reply helpful? Yes No
Suggested answer

CU03011658-0 2 on at

Like (0)

Report
Copy link

Link copied!

I just had the same problem and finally found the answer. @@Mark Nanneman

The function is called "in"

(i am german, so all this is in german) with this function it is looking for the string "Herr" in my variable called "NameHerrFrau" containing the text "Herr Michael Vanguard" or so.

@Mark Nanneman: what you show is the solution when power fx is not turned on. if you turn it on, you have much less choice in the if function, but much more possibilities with the formulars you put in.

Was this reply helpful? Yes No