Share
ReportIs there a way to edit/select a column that I created with AddColumns and use for example a Filter with that Column somwhere else?
Categories:
You’re offline. This is a read only version of the page.
45
Is there a way to edit/select a column that I created with AddColumns and use for example a Filter with that Column somwhere else?
Hi @TKEnes ,
If you want to edit the value of a field created by the Addcolumns() function, maybe you need to use the ClearCollect() function to store this temporary table. Then you could use the Patch() function to update the collection.
In addition, here are some links that might help you:
http://powerappsguide.com/blog/post/set-form-data-source-to-a-collection
https://powerusers.microsoft.com/t5/Building-Power-Apps/Form-won-t-show-collection-data/td-p/42223
If you want to filter this temporary table, try the formula like this:
All responses (
Answers (
Filter(AddColumns(DataSource,"NewColumnName",Formula),StartsWith(NewColumnName,TextInput1.Text))
Best Regards,
Charlie Choi
