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)

Sort by

Michael E. Gernaey 53,968 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry is there a question?

also what order is your collection?

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

Like
a
(0)

Report
Copy link

Link copied!

Sorry is there a question?

also what order is your collection?

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

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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