Calculation reference from 1 field or another if empty

(0) Share

Report

Posted on by srikant

Hi All,

I want to create a distinct colA and ColB, if ColA is empty need to display ColB and viceversa in Gallery

ColA	Col B
1	1
2	2
3	3
4
	1
4

Categories:

Power Apps portals

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Inogic 1,291 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

To achieve a distinct display of ColA and ColB in a Power Apps Gallery where, if ColA is empty, it shows ColB and vice versa, you can follow these steps:

Solution Steps:
Prepare the Data Source: Ensure your data source has ColA and ColB fields as shown in your example.

Add a Gallery Control: In Power Apps, add a Gallery control to your screen and connect it to your data source.

Display Logic for Distinct Values: To create a distinct list where either ColA or ColB is shown based on availability, you can use the following formula in the Gallery’s Items property:

powerfx
Copy code
ForAll(
    Distinct(
        Filter(
            YourDataSource,
            Not(IsBlank(ColA)) Or Not(IsBlank(ColB))
        ),
        If(
            IsBlank(ThisRecord.ColA),
            ThisRecord.ColB,
            ThisRecord.ColA
        )
    ),
    { DisplayValue: Result }
)
Explanation of the formula:
Filter: Filters records to include only those where either ColA or ColB is not blank.
Distinct: Ensures unique values in the list.
If: Checks if ColA is blank. If so, it uses ColB; otherwise, it uses ColA.
ForAll: Creates a record for each distinct value with a DisplayValue field, which you can use to display in the Gallery.
Display the Result in the Gallery:

Set a label within the Gallery to display ThisItem.DisplayValue.
This will display the unique values from ColA and ColB in your Gallery based on your specified conditions.

Hope this helps.

Thanks!

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,992 Super User 2025 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Use the AddColumns function with If(IsBlank(...)) to add a new column that checks for values in ColA and displays ColB if ColA is blank.

Set the Items property of the Gallery

AddColumns(
Distinct(MyCollection, ColA & ColB),
"DisplayValue",
If(
!IsBlank(ColA), ColA,
ColB
)
)

In the gallery, bind the Text property of a label control to ThisItem.DisplayValue to show either ColA or ColB based on availability.

it should fix, let me know if you need more details.

Was this reply helpful? Yes No