News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Set Variable empty value

Power Automate - Building Flows

Unanswered

Set Variable empty value

Like (0) Share

Report

Report

Posted on 19 Sep 2023 17:58:01 by KhrystinaM

158

I am trying to build a multiple approval workflow the will return the approval comments in the email I tried setting it up multiple times.

Test 1

If approved, update SharePoint
send 2nd approval to manager with associate approval comments in email from update SharePoint
- creates an apply to each for every approval comment (Form is built to have up to 3 associate approval comments)

Test 2

Create an initialize variable for each approval comment so apply to each does not happen on manager approval flow
- error message when Associate 3 comment section blank
  - How do I set my variable to return NA if null?

Categories:

Business Process Flows

All responses Img

All responses (6)

Answers Img

Answers (0)

KhrystinaM 158 on 26 Sep 2023 at 16:57:18

Like (0)

Report

Re: Set Variable empty value

@Sundeep_Malik Hello, I tried both options on the set variable field and got this error.

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_-_Associate_3' failed: the result of the evaluation of 'foreach' expression '@outputs('Associate_3_Approval')?['body/responses']' is of type 'Null'. The result must be a valid array.
Sundeep_Malik 6,480 on 19 Sep 2023 at 19:11:41

Like (0)

Report

Re: Set Variable empty value

@KhrystinaM

You can directly write the following expression:

if(equals(items('Apply_to_each_-_Associate_3')?['comments'],''),null,items('Apply_to_each_-_Associate_3')?['comments'])

If the above does not work, replace '' with null

I hope this helps 🙂
KhrystinaM 158 on 19 Sep 2023 at 19:04:00

Like (0)

Report

Re: Set Variable empty value

@Sundeep_Malik I input the following.

if(equals(variables('Associate_3_Approval')?['body/outcome']),null),'NA',variables('Associate_3_Approval')?['body/responseSummary']))

I'm getting this error
Flow save failed with code 'WorkflowRunActionInputsInvalidProperty' and message 'The inputs of workflow run action 'Set_variable_4' of type 'SetVariable' are not valid. Self reference is not supported when updating the value of variable 'varAssociate3'.'.

Should my initialize variable have a value? I tried adding a value and removing the set variable, but I got an error for that as well.
Sundeep_Malik 6,480 on 19 Sep 2023 at 18:28:48

Like (0)

Report

Re: Set Variable empty value

Oh my bad.

Actually replace variables('VariableName')

part with the comment expression.
KhrystinaM 158 on 19 Sep 2023 at 18:19:54

Like (0)

Report

Re: Set Variable empty value

@Sundeep_Malik Do I apply option 2 to the set variable? I tried that and I'm getting an error.
Sundeep_Malik 6,480 on 19 Sep 2023 at 18:02:30

Like (0)

Report

Re: Set Variable empty value

Hey @KhrystinaM

You can write a similar expression as below:

1)

If(equals(variables('VariableName'),''),'NA',variables('VariableName'))

2)

If(equals(variables('VariableName'),null),'NA',variables('VariableName'))

I hope this helps 🙂

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,662 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans