cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Help with arrays (i think)

Hi,

 

I have a form that is letting people add items that they want to buy, one at a time.  At any point there can be 1 or more items.

 

In my flow, the prices are calculated, by initialising and setting the variables.

 

However, if I have less than 5 variable set my flow fails.

 

I think I need to use an Array, but I am unsure.

 

My flow looks like thisflow.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

I think I have fixed this, I have now got a condition based on whether a customer answered yes to add another line (variable2 etc) and if they didn't it just stops at that point.

 

It looks massive, but it will work

View solution in original post

10 REPLIES 10
efialttes
Super User III
Super User III

@Anonymous 

Can you share the details of the expressions you use in your "set variable"'s?

Also, if they come from the Microsoft Forms responsas, can you share details on the Form itself?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Anonymous
Not applicable

So the set variable looks like this

 

mul(int(body('Get_response_details')?['r01dd8cab3c154b5186fb8e3c692f85e8']),float(body('Get_response_details')?['rb2441aaaef334619b92d5e838a688338']))
 
And that comes from the form

Hi again

According to the official documentation, funcion int() expects a string, so... can you share an example of

body('Get_response_details')?['r01dd8cab3c154b5186fb8e3c692f85e8']

as it is displayed on the Get REsponse Details output?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Anonymous
Not applicable

Hi,

 

Sure, thanks for your assistance.

 

"r01dd8cab3c154b5186fb8e3c692f85e8": "2",


The Flow works if all variables are set, its only when not all five are set that it fails

@Anonymous 

What are your requirements when not all five variables are set?

 

I mean, you can for example try to use coalesce() function to set a variable with a default value in case the corresponding response could not be obtained from the form response

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Anonymous
Not applicable

I see what you mean, but I don't think that will work as it will populate the subsequent email with default info

 

 

Anonymous
Not applicable

if we go with the coalesce example.

 

Where would I use that function ?

@Anonymous 

I need more details about what you are trying to build, can yo detail what expressions you to set the value in each variable, what field in the survey is optional and which one is mandatory, and which requirements you have in order to write the content of the email in case any of the fields in this survey has no response

Thankx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Anonymous
Not applicable

I think I have fixed this, I have now got a condition based on whether a customer answered yes to add another line (variable2 etc) and if they didn't it just stops at that point.

 

It looks massive, but it will work

View solution in original post

Anonymous
Not applicable

thanks a lot for your help !

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (28,768)