Powerfx syntax for multiple conditions and multiple actions

(0) Share

Report

Posted on by MP-03020017-0

What is the correct syntax for the following. I've tried using two semicolons between the actions, I've tried wrapping the actions in curly brackets. Please let me know if you have a working version of something like this. I am in Canada. I understand there are some locale differences in syntax for powerfx.

If(
conditionA ||
conditionB ||
conditionC,

Set(varName,
Patch(
'sitename',
Defaults('ListBName'),
{
Title: "Details",
First_x0020_Name: varItem.First_x0020_Name,
Last_x0020_Name: varItem.Last_x0020_Name,
}
)
);
'PowerAutomateFlowName'.Run(
        'FormName'.LastSubmit.ColumnName & " Some Text",
        varItem.ID,
        varName.ID,
        "Another value"
    )
);

...

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

SebS 4,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

it should look like this I added With() So it's more safe to validate the ID exist

If(
conditionA || conditionB || conditionC,

With(
{
_record:
Patch(
'sitename',
Defaults('ListBName'),
{
Title: "Details",
First_x0020_Name: varItem.First_x0020_Name,
Last_x0020_Name: varItem.Last_x0020_Name
}
)
},
Set(varName, _record);
'PowerAutomateFlowName'.Run(
'FormName'.LastSubmit.ColumnName & " Some Text",
varItem.ID,
_record.ID,
"Another value"
)
)
)

Let me know if it works for you hard to check from my end :)

Was this reply helpful? Yes No
WarrenBelz 153,698 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @MP-03020017-0,

Firstly @SebS's structure is more ideal as it eliminates an unnecessary variable (and I have used it below), however I think your issue lies elsewhere. You are patching the site instead of the list.
If( conditionA || conditionB || conditionC, With( { _Name, Patch( 'ListBName', Defaults('ListBName'), { Title: "Details", First_x0020_Name: varItem.First_x0020_Name, Last_x0020_Name: varItem.Last_x0020_Name, } ) }, 'PowerAutomateFlowName'.Run( 'FormName'.LastSubmit.ColumnName & " Some Text", varItem.ID, _Name.ID, "Another value" ) ) );

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No