Unanswered

Need help adding a column to a collection with conditional logic

(0) Share

Report

Posted on by Cgangweg01

690 Super User 2025 Season 2

Hello -

Need help adding a column to a collection with conditional logic.

The expression below to add the Zone column to the collection works with the single if statement but what I need to do is the following:

If 'Store Number' is values 1 - 3 then Zone value is "A"
If 'Store Number' is values 4 - 8 then Zone value is "B"

Appreciate any suggestions!

ClearCollect(
ColStorePriceswithfilterwithZone,
AddColumns(
ColStorePriceswithFilter,
Zone,
If(
'Store Number' = 4,
"B"
)
)
);

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

victorcp 2,350 Moderator on at

Like (2)

Report
Need help adding a column to a collection with conditional logic

Hey! hope you are doing fine

you can just add the other conditions like this:

ClearCollect( ColStorePriceswithfilterwithZone, AddColumns( ColStorePriceswithFilter, Zone, If( 'Store Number' in [1,2,3], "A", 'Store Number' in [4,5,6,7,8], "B" // you can add as many conditions as you want ) ) );

Hope it helps :)

Was this reply helpful? Yes No
Cgangweg01 690 Super User 2025 Season 2 on at

Like (0)

Report

Need help adding a column to a collection with conditional logic

Thank you victorcp!

Done!

Was this reply helpful? Yes No