Answered

Collect Toggle Switch Value write to dataverse Yes/No

(0) Share

Report

Posted on by mikerosoft_user

As subject line states, I have a canvas app with a toggle switch (Toggle1) that I want to Collect() with a button and write the value to a dataverse table column (Col1) which is of type Yes/No

In the button 'OnSelect' field I enter:

`Collect(table, {Col1:Toggle1.Value})`

This returns the error:

"The function Collect has some invalid arguments. Incompatible type. The Col1 column in the data source you're updating expects 'OptionSetValue' and you're using a 'Boolean' type. "

I've scoured the forums to no avail.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
In the button try
If(Toggle1.Value=true,Collect(table, {Col1:choicename.Yes),Collect(table, {Col1:choicename.No))

Choice name can be found in reference to below image example "aaaaaa" in this case

OR it can be found with reference to below image

`

Was this reply helpful? Yes No
mikerosoft_user 14 on at

Like (0)

Report
Copy link

Link copied!
I'm not entirely sure what you mean by choice names. As in use the label under 'Choices'? Note that the real column name is displayed here instead of alias.

If(Toggle1.Value=true, Collect(table, {wasAnxious:Yes.Yes}),Collect(table, {wasAnxious:No.No}));
This still results in an Error.

Was this reply helpful? Yes No
Manan-Malhotra 621 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
If(Toggle1.Value=true, Collect(table, {wasAnxious(@table):Yes.Yes}),Collect(table, {wasAnxious(@table):No.No}));
In your case you will see a name in this way "wasAnxious(@table)" where you will get a wasAnxious(@table).yes or wasAnxious(@table).no

Please follow this syntax after using the following above name
If(Toggle1.Value=true,Collect(table, {Col1:choicename.Yes),Collect(table, {Col1:choicename.No))

Was this reply helpful? Yes No
mikerosoft_user 14 on at

Like (0)

Report
Copy link

Link copied!

I appreciate the help but it's just not working for me (totally new to powerapps). To reproduce the example verbatim:
my table is called : records
the column to update: wasAnxious
toggle switch name: Toggle1
And the create statement is placed in a button 'OnSelect' field.

I appreciate the help, and will mark as correct answer if I can get it to work. Thanks again.

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You say you want to collect the value and write it to a dataverse table. Is there a reason not to just write it to the table?

For a new record, try this is your button's OnSelect: Patch(records, Defaults(records), {wasAnxious: 'wasAnxious (MyTables)'.Yes})

To have the value depend on the toggle, you have the solution from @Manan-Malhotra :

If(Toggle1.Value=true, Patch(records, Defaults(records), {wasAnxious: 'wasAnxious (MyTables)'.Yes}), Patch(records, Defaults(records), {wasAnxious: 'wasAnxious (MyTables)'.No}) )

Was this reply helpful? Yes No
Verified answer

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
If(Toggle1.Value=true, Patch(records, Defaults(records), {wasAnxious: 'wasAnxious (MyTables)'.Yes}), Patch(records, Defaults(records), {wasAnxious: 'wasAnxious (MyTables)'.No}) )

@mikerosoft_userplease try the following code as given below
Hope this works for you

Please Accept as Solution if it solves your question Or just give it a Thumbs Up if it is helpful because this can help others.
LinkedIn: https://www.linkedin.com/in/manan-malhotra-vfx/
Want to support me! Buy me a Cup of Coffee?

Was this reply helpful? Yes No