Collecting Combo Box Values in my Data Verse

(1) Share

Report

Posted on by DM-12091425-0

Hi All,

Have Added a Classic Combo Box to my App.

This Combo is displaying my Choices from a table I created in Data Verse, below is the formulae for this:

Choices('Reason-For-Contact (TestingTableOOOS)')
<<Reason_For_Contact is the Column Name>> / <<TestingTableOOOS>> is the Data Verse Table
 
For Context I am trying to capture my data from the App into this same table / Column, so the column in question is set a multiple choice field.
 
The below is the formulae I am using for the collection within the App
Collect(TestingTableOOOS,{'Reason-For-Contact':Reason_For_Contact_Value})
 
This is the error I am receiving:
 
I am expecting there is something wrong with my formula? Can anyone help me? 
 
Thanks
Dan

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

NPPlatform 606 Moderator on at

Like (3)

Report

Reason_For_Contact_Value is referencing an entire control, instead of a specific property of that control. You need to add a dot ( . ) behind your control in the formula, then you'll see the available properties to choose from.

Was this reply helpful? Yes No
Verified answer

Nandit 1,568 Moderator on at

Like (2)

Report
Hi DM-12091425-0,

Just to confirm, are you trying to save multiple values to the column using ComboBox? If yes, then formula will be different to the one I have suggested below.

Use the following instead:

Collect(TestingTableOOOS,{'Reason-For-Contact':Reason_For_Contact_Value.Selected.Value})

Also, Collect will only save the data in the app, not patch it to the source. You will need to use a Patch function for that.

For multiple selection use the following:

Collect(TestingTableOOOS,{'Reason-For-Contact':Reason_For_Contact_Value.SelectedItems})

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
DM-12091425-0 41 on at

Like (0)

Report

Thank you Nandit :) That did the trick, really appreciate the explanation too that helped alot :)

We keep learning!

Best Wishes

Dan

Was this reply helpful? Yes No