Unanswered

ClearCollect not working on choices

(0) Share

Report

Posted on by ctedesco3307

938

Hello - I have a ClearCollect on a page to allow users to update choices - it all works - but if I make more than one change (add update or delete a choice) if I run ClearCollect again and the collection does not refresh.

ClearCollect will work once then not subsequent times

any workarounds here? thx

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Where in your app are you running the ClearCollect? If its the OnVisible property that only runs the first time the screen is loaded. The other problem is that making a change to the schema of a backend data source won't take effect in the application until the data source is refreshed.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
ctedesco3307 938 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 its on the OnSelect property of a button and the collection is directly to the Global Choice List not a table. if I try and do a Refresh(GlobalChoiceList) I get an error only Managed connections can be refreshed.

Was this reply helpful? Yes No
Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Try doing a Refresh on the Table that uses the GlobalChoiceList. That may Refresh the connection to the list.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
ctedesco3307 938 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 - yeah - I thought of that already - no luck

Was this reply helpful? Yes No
ctedesco3307 938 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 If I do a hard refresh by clicking on the '...' in the side data panel and then run the clear collect it works but using the Refresh() function on the button does not - tried both of these options

Was this reply helpful? Yes No
Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, That is about what I expect. Refresh(DataSource) as a statement refreshes the Data in the Data Source, but not the schema. What you are doing makes a change to the Schema itself. So that requires a Refresh of the Connection itself, not just the data.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
JuanF 5 on at

Like
a
(1)

Report
Copy link

Link copied!
First I would ask myself: is "colExceptions" collection not updating correctly or is it the dropdown that is not showing additions/deletions? Because I would troubleshoot either differently.

You can also try to make direct additions onto the Collection by using Collect.

Add

Collect( MyCollectionName, { FieldName1: Value } )

Or Delete

Remove(MyCollectionName, LookUp(YourCollection, Column = Dropdown.Selected.Value))

Or Update

Update(MyCollection, LookUp(MyCollection, ColumnFromCollection = Dropdown.Selected.Value), { Column: Value, Column2: "Text", Column3: 30 })

Essentially, you don't need to clear the collection everytime you are changing it. Hopefully this will help you troubleshoot your issue. Another way could be to create a secondary Collection and use that to feed the other. Cheers.

Was this reply helpful? Yes No