Answered

Drop Columns not working?

(1) Share

Report

Posted on by MV-30041934-0

What is wrong with this formula? The error I'm getting is on the rename columns step stating that "a column named field_6 already exists". But I'm literally dropping the field_6 column in the previous step. Does drop columns simply not work? This should be taking the email addresses in field_6, making them insensitive by running them through the Lower function and saving them to a new field, then drop the original field_6 and rename the new field to field_6. When I view the collects created at these various steps, those columns do not appear in the collections. This code worked fine six months ago.

ClearCollect(formattedcolSecurityAll,

RenameColumns(

DropColumns(

AddColumns(

colSecurityAll

,insensitivefield_6,Lower(field_6))

,field_6)

,insensitivefield_6,field_6));

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

Sort by

rzuber 552 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@dsagfhjj try

With( {_records: DropColumns(AddColumns(colSecurityAll, insensitivefield_6, Lower(field_6)), field_6)}, ClearCollect(formattedcolSecurityAll, RenameColumns(_records, insensitivefield_6, field_6) );

To answer your question, I believe the issue here is that Power Apps is declarative.. Meaning it's trying to remove and add the column at the same time, and it doesn't understand how to do that..

To fix it, you define the table inside the context record of the With() statement, and then collect the defined table with the renamed column into the collection.

Was this reply helpful? Yes No
MV-30041934-0 97 on at

Like
a
(1)

Report
Copy link

Link copied!

This gives the same error.

Was this reply helpful? Yes No
rzuber 552 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@dsagfhjj Strange... I will do some testing and report back.

Was this reply helpful? Yes No
rzuber 552 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@dsagfhjj What if you change it to:
With( { _records: RenameColumns( DropColumns(AddColumns(colSecurityAll, insensitivefield_6, Lower(field_6)), field_6), insensitivefield_6, field_6 ) }, ClearCollect(formattedcolSecurityAll, _records) );

Was this reply helpful? Yes No
rzuber 552 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@dsagfhjj I have tried both of my suggestions on a temporary table, and received no errors.. There is another element to this puzzle we are missing.

Was this reply helpful? Yes No
MV-30041934-0 97 on at

Like
a
(1)

Report
Copy link

Link copied!

Same error.

Was this reply helpful? Yes No
MV-30041934-0 97 on at

Like
a
(1)

Report
Copy link

Link copied!

Maybe I have the collection being used somewhere else? I'll have to look around.

Was this reply helpful? Yes No
rzuber 552 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@dsagfhjj Can you show me a screenshot showing where all the squiggly lines are in your formula?

Was this reply helpful? Yes No
Verified answer

rzuber 552 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
@dsagfhjj What if you change it to

ClearCollect( formattedcolSecurityAll, ForAll( colSecurityAll As _record, Patch(_record, {field_6: Lower(_record.field_6)}) ) );

Was this reply helpful? Yes No
MV-30041934-0 97 on at

Like
a
(1)

Report
Copy link

Link copied!

Was this reply helpful? Yes No