Merge Columns in Collection

(0) Share

Report

Posted on by Spaceballs

Hi Fam,

I'm struggling how to merge column with conditional into a new column from the same Collection.

CollectionA

Column1	Column2	Column3	ID
Other	ABC		1
Apple			2
Orange			3
		Vegetable	4
		Meat	5

Output of the CollectionA should look like this:

Column1	Column2	Column3	MergedColumn	ID
Other	ABC		ABC	1
Apple			Apple	2
Orange			Orange	3
		Vegetable	Vegetable	4
		Meat	Meat	5

This is my formula to collect specific column based on the selected dropdown

ClearCollect(CollectionA, 
 ShowColumns(Filter(SharePointList, Category = CategoryDropdown.Selected.Value)
 
 //SharePoint Columns
 , "Column1"
 , "Column2"
 , "Column3"
 , "ID")
)

How do I merge the Column1 and Column2 and Column 3 into a New Column?

Here is the logic

If Columns 3 isblank then Column1 but if Column 1 = other then grab Column2 else Column 1

Thanks

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

Spaceballs 64 on at

Like
a
(0)

Report
Copy link

Link copied!
Never mind I think I figured it out

UpdateIf(CollectionA, IsBlank(Column3), { Column3: Column1 } ); UpdateIf(CollectionA, Column3 = "Other", { Column3: Column2 } )