Answered

any other option to nested if function?

(0) Share

Report

Posted on by cheezy

148

Just looking to be pointed in the right direction regarding nested if statements/functions for a flow i will be creating.

The flow (triggered on power app form submission) could have the possibility of 40 different options (instructions) that need to populate an email.

My thinking initially was to use a switch connector but the number of options will be greater than 25 and it also means having multiple email templates.

So now i am thinking having one email template based on 40 compose connectors - each compose would have the instruction text and part of this text would have a date calculation based on date values chosen in the app. And then populating a single email template with a function based on a nested if

ie if instruction = value 1 then use Compose1

instruction = value 2 then use Compose2

etc all the way up to compose 40.

are there any better, more efficient ways to do this?

thanks

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@cheezy

I would say if you can keep a configuration list in SharePoint or any other source where you where you keep option and required template and then do a Get Items / or List Rows and use a Filter Query based on the input parameter passed from Powerapps , it would be a good idea and easily extended if you have new options.

Was this reply helpful? Yes No
cheezy 148 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for response.
the bit i dont get above with a list is how do i included date calculations in a template?

for example instructions may included something similar to this:
"On the day before your appointment on [date calculation based on appointment date] you will be required to do this blah blah
2 days prior to your appointment on [date calculation based on appointment date] you will need to do this blah blah blah"

i can easily achieve this in a compose but not sure how in a template

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@cheezy

You can do placeholders in the template for the calculated fields like text {0} and then replace in your flow but if the calculation is also per selected option in the same row you can add number of days, do the whole calculation on flow and replace placeholders in template,Does this makes sense?

Was this reply helpful? Yes No
cheezy 148 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks but dont understand, for example how would this work in example above?
say appt date is 3/5/2022
On the day before your appointment on [placeholder 1] you will be required to do this blah blah
2 days prior to your appointment on [placeholder 2] you will need to do this blah blah blah

so what i would want is placeholder1 to equal 2/5/2022 and placeholder2 to be 1/5/2022 ?

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@cheezy

Can I ask a Question Back is 2 days prior something consistent or different between Templates?

Was this reply helpful? Yes No
cheezy 148 on at

Like
a
(0)

Report
Copy link

Link copied!

different unfortunately.
these would be the combinations:
some may have 1 day prior only, some would have 1day and 2 day prior and others 1day,2 day and 3 day prior.

Was this reply helpful? Yes No

Verified answer

Mira Ghaly

11,415 Moderator on at

Like (0)

Report

Copy link

Link copied!

@cheezy

So you list needs to look like below

Option	Number of Days	Template
Option 1	2	Text before place holder for Option 1 {0} Text After place holder for Option 1
Option 2	1	Text before place holder for Option 2 {0} Text After place holder for Option 2