Answered

PowerFx formula error: Identifier not recognised

(0) Share

Report

Posted on by Siziwe

Hi guys, I have a question. I'm trying to add a conditional node here with the following expectation: Whenever the last message/trigger message has the words "access" OR "license" then lead the user to a certain path on the workflow. This is the code I've been getting on preview:

Text(Topic.Message).contains('license') || Text(Topic.Message).contains('access')

However, it's been giving me issues. I tried a workaround with the IF statement however, it doesn't truly work for my kind of logic. Is there a different approach I can maybe look into?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

HenryJammes Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Siziwe ,

I have the below example that you can reuse to meet your objective.
I actually use the LookUp formula in Power Fx.

I first setup a table variable with my list of keywords:

[
{ Keyword: "Access" },
{ Keyword: "License" },
]
I then check if the user question contains the keyword or not (in lowercase):

!IsBlank(
LookUp(
Topic.Keywords,
Lower(Keyword) in Lower(Topic.Question)
)
)

You can reproduce this by pasting the below YAML in a new topic:

kind: AdaptiveDialog beginDialog: kind: OnRecognizedIntent id: main intent: displayName: Keyword Condition triggerQueries: - Keyword condition actions: - kind: Question id: question_7REwVb interruptionPolicy: allowInterruption: true variable: init:Topic.Question prompt: What is your question? entity: StringPrebuiltEntity - kind: SetVariable id: setVariable_Xi46xv variable: Topic.Keywords value: |- =[ { Keyword: "Access" }, { Keyword: "License" }, ] - kind: SetVariable id: setVariable_5QF2kS variable: Topic.ContainsKeyword value: |- =!IsBlank( LookUp( Topic.Keywords, Lower(Keyword) in Lower(Topic.Question) ) ) - kind: ConditionGroup id: conditionGroup_ZXXmnq conditions: - id: conditionItem_DVxsJB condition: =Topic.ContainsKeyword = true actions: - kind: SendActivity id: sendActivity_dS0W20 activity: Your question contained a matching keyword. elseActions: - kind: SendActivity id: sendActivity_KB9kMN activity: Your question didn't contain a matching keyword.

Let me know if that helps

Was this reply helpful? Yes No
Siziwe 38 on at

Like (0)

Report
Copy link

Link copied!

Hi @HenryJammes I'll test this out and get back with some feedback. Thank you so much.

Was this reply helpful? Yes No
Siziwe 38 on at

Like (0)

Report
Copy link

Link copied!

Hi @HenryJammes,
The solutions worked. Thank you for your support.
A question from my end - is there a resource guide you can direct me to learn more about these formulas or the LookUp function will help a lot?

Was this reply helpful? Yes No
HenryJammes Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

There is the Power Fx formula language documentation or a few examples that apply to PVA here: https://learn.microsoft.com/en-us/power-virtual-agents/advanced-power-fx

Was this reply helpful? Yes No
Siziwe 38 on at

Like (0)

Report
Copy link

Link copied!

Thanks @HenryJammes !

Was this reply helpful? Yes No
HenryJammes Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@Siziwe wrote:
Thanks @HenryJammes !
No worries, keep them coming - we're looking at documenting as many examples and "how to" as possible to ease adoption.

Was this reply helpful? Yes No
debr92 2 on at

Like (0)

Report
Copy link

Link copied!

Hello @HenryJammes , thanks for this. I am trying out something similar and this has helped me. Next thing I am looking for is something like if the user input has license in his input, it needs to call Flow1, if it has "Access" then flow 2 otherwise some default flow. Something like "I want my license renewed" - should trigger flow 1 identifying keyword as license. how can I do that?

Was this reply helpful? Yes No
adilei Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Why not use trigger phrases/entities for that?

Was this reply helpful? Yes No