Unanswered

renameColumns will cause collection column sequence change!!!

(0) Share

Report

Posted on by fgu3029

I'm in china, assume you have a collect with column a_xx, b_yy, c_zz(xx/yy/zz is a chinese char), if you want to remove the prefix of a_, b_, c_, you use a renameColumns function:

Collect(_newOne, RenameColumns(

"a_xx","xx",

"b_yy", "yy",

"c_zz", "zz")

)

the _newOne collection columns sort is not as expected sequence as: xx-yy-zz.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Michael E. Gernaey 53,479 Super User 2025 Season 2 on at

Like (0)

Report

Sorry is there a question?

also what order is your collection?

Was this reply helpful? Yes No
Michael E. Gernaey 53,479 Super User 2025 Season 2 on at

Like (0)

Report

Sorry is there a question?

also what order is your collection?

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
Hi , @fgu3029

According to your description, you use the renamecolumns() function to update the column name.

I test it in my side :

Set(datatest, [{a_名字:"zyy",b_班级:"Class1",c_成绩:20},{a_名字:"zyy2",b_班级:"Class2",c_成绩:30},{a_名字:"zyy3",b_班级:"Class3",c_成绩:40} ]); Set(dataetst2 , RenameColumns(datatest ,"a_名字","名字","b_班级" , "班级","c_成绩" ,"成绩"));

And this should just be some kind of initials to show the data of the column.This is by design in Power App.

Do you mean the [成绩] column convert to before the [班级] column?

If that's the case, that's okay, because all the controls can set their own display position, as long as they have the corresponding data.

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
fgu3029 76 on at

Like (0)

Report

thank u very much!

Yes, maybe with apps, It's OK (you can set display column & display order in dataset or gallery), but I will export collection to a excel file, so the collect order is very import for me.

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

Hi , @fgu3029

Thanks for your quick response!

Which method your export to the Excel file , do you use the flow to export ? If you use the flow , you can use the "Select" action to reorder your array field .

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
fgu3029 76 on at

Like (0)

Report

yes, use a flow to export,
1, In apps, parse collect to json
2, use a flow to export to excel (Premisely put the apps parseJson result into flow parseJson function)
→ so then collection column sequence is the final excel sequence.
col1:学号（No)
col2:姓名（Name)
col3:学科（Subject)
col4:成绩（Score)
So the collect column sequence is very import for me!

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

Hi , @fgu3029

You can use the "Select" action in your flow to custom the column sequence in your flow, like this:

In Power App , you just need to pass a table.

Set(datatest, [{a_名字:"zyy",b_班级:"Class1",c_成绩:20},{a_名字:"zyy2",b_班级:"Class2",c_成绩:30},{a_名字:"zyy3",b_班级:"Class3",c_成绩:40} ]);

Set(dataetst2 , RenameColumns(datatest ,"a_名字","名字","b_班级" , "班级","c_成绩" ,"成绩"));

renameColumnswillcause.Run( JSON(dataetst2) );

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No