Unanswered

Remove a field from a collection

(0) Share

Report

Posted on by joseabarriga

Hi!:

Working in my app, for some reason that I can´t figure it out a new field was added to a collection. Even though I made all kinds of "Clear" command, in the Run on Startup, in On visible, saving closing, even not running the app, there still a "sticky" field (image) that I can´t remove. Also, I tried with a different collection and adding them "fake" fields, and after Clear the collection they disappeared.

Is there a command or whatever that we can "destroy" a Collection and recreate it?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

eka24 20,923 on at

Like (0)

Report

If the Collection is taken from a table, try this OnSelect of a collection or Onvisible;

ClearCollect (Coll1,DropColumns(Datasource,"ColumnToRemove"))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
joseabarriga 25 on at

Like (0)

Report

Thks for the response but it did not work since the "ColumnToRemove" is not contained in the Datasource.

That is precisely the "rare" thing.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Please you are supposed to replace ColumnToRemove with the name of the field you want to remove. If the name of the collumn in the Collection is ABC replace ColumnToRemove with ABC.
I don't know the column name that is why I used ColumnToRemove

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi@joseabarriga,
Could you please share more about this new field? A screenshot will be appreciated.
I have seen your previous issues related to this 'new field'. Do you mean you can not remove the new field from the collection which originally created by Excel table?
If I understand correctly, please remove your current data source whatever it is a custom connector or a collection, please connect to your original Excel table.
Best Regards,
Qi

Was this reply helpful? Yes No