How do you Embed Multiple Functions in IF Statements?

(0) Share

Report

Posted on by Ginko

221

I'm struggling to create the else_value of an IF statement that would populate the Items of a dropdown.

I've tried many form's of the else_value filter but it still demand's a text data type while telling me its text data type. I thought making it distinct and calling out the ImageName column that I would like to be the selections of the dropdown, but that did not solve it.

I believe the issue is that the else_value is an embedded function within two others functions, because if you place "Distinct(Filter(PERImageStorage, Focus = Dropdown1_1.Selected.Step), ImageName)" alone in a dropdown as its Item's, the function works correctly. How do I embed this function as the else_value in this IF statement?

If(IsBlank(Filter(PERImageStorage, Focus = Dropdown1.Selected.Result)), Label1.Text, Distinct(Filter(PERImageStorage, Focus = Dropdown1_1.Selected.Step), ImageName))

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Ginko ,

That is because both possible outcomes need to be Tables

If( IsEmpty( Filter( PERImageStorage, Focus = Dropdown1.Selected.Result ) ), Table({Value: Label1.Text}), Distinct( Filter( PERImageStorage, Focus = Dropdown1_1.Selected.Step ), ImageName ) )

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Ginko 221 on at

Like
a
(0)

Report
Copy link

Link copied!

Wow, wouldn't have thought it was on the true part of the statement, learned something new! Thanks!