Power Platform Community Forum Thread Details

Hello,

I have a Collection that is made up of 3 tables (soon to be 4),
They all have similar columns: a description, a date, a name.

I would like to save them in my collection under the same column.

My formula is currently something like:

ClearCollect(
 Nudges,
 ShowColumns(
 'Data',
 "ddnudgedescription",
 "message",
 "programmecode",
 "Engagement",
 "enabledflag",
 "Related_Report",
 "source",
 "ddnudgetemplateid",
 "CurrentDate",
 "SpecificDate"
 )
);
Collect(
 Nudges,
 ShowColumns(
 'Data2',
 "nudgedescription",
 "message",
 "programmecode",
 "Engagement",
 "enabledflag",
 "deliverydate"
 )
);
Collect(
 Nudges,
 ShowColumns(
 'Data3',
 "Question_Description",
 "Question_text",
 "Date",
 "Enabled_flag",
 "Engagement"
 )
)

So I would like to - for example - save "Date" from 'Data3', "deliverydate" from 'Data2' and "SpecificDate" from 'Data' into one column named 'Date' in my collection.

Is this possible?
they are of the same data types

Thanks for any help

Categories:

Building Power Apps

Figured it out

had to use rename columns in this order

ClearCollect(
 Nudges,
 ShowColumns(
 RenameColumns(
 'Data',"SpecificDate","Date","ddnudgedescription","Description"),
 "Description",
 "message",
 "programmecode",
 "Engagement",
 "enabledflag",
 "Related_Report",
 "source",
 "ddnudgetemplateid",
 "CurrentDate",
 "Date",
 "ddnudgeid"

 )
);
Collect(
 Nudges,
 ShowColumns(
 RenameColumns(
 'Data2',"deliverydate","Date","nudgedescription","Description"),
 "Description",
 "message",
 "programmecode",
 "Engagement",
 "enabledflag",
 "Date"
 ,"nudgeid"
 )
);

Collect(
 Nudges,
 ShowColumns(
 RenameColumns(
 'Data3'
 ,"Question_text", "message","Question_Description","Description"),
 "Description",
 "message",
 "Date",
 "Enabled_flag",
 "Engagement",
 "Question_ID"
 )
)