Unanswered

Set variable to collection - Unexpected character. The formula contains 'Ident' where 'Data' is expected

(0) Share

Report

Posted on by Rogal123

Hi,

I encountered a problem when defining variables. First, I assigns collection from the sql database to a variable (onVisible property of screen):

Set(varMyCollection, Filter(Table1, ID = varSelectedUser));

Then I set the DefaultSelectedItems parameter of the combobox to varMyCollection.

Up to this point everything is working fine.

In the next step, I add a button that is responsible for adding new values to Table1. After each addition, I want to refresh the currently selected items with this code

Patch...
Refresh(Table1);
Collect(varMyCollection, Last(Table1));
Reset(Combobox);
Collect(varMyCollection, Filter(Table1, ID = varSelectedUser));

The problem is that when adding the above code to the button, there is an error in the onVisible property of screen next to my Set(varMyCollection.... that says: Unexpected character. The formula contains 'Ident' where 'Data' is expected

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
I think that you should have this:

ClearCollect(colMyCollection, Filter(Table1, ID = varSelectedUser));

After that, set the DefaultSelectItems as colMyCollection

After that:

Patch... Refresh(Table1); Collect(colMyCollection, Last(Table1)); Reset(Combobox); Collect(colMyCollection, Filter(Table1, ID = varSelectedUser));

Bu tthis will duplicate some data... Tell me what you really want to do

Was this reply helpful? Yes No
Rogal123 2 on at

Like
a
(0)

Report
Copy link

Link copied!

When trying to use ClearCollect, the combobox is empty at view/edit instead of displaying values.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-clear-collect-clearcollect

You can use only Collect but ClearCollect should clear the data and after that re-add

Was this reply helpful? Yes No