Selected Value from Gallery submitting to Sharepoint

[mezcalbean]

Hi,

I have a canvas app with two data cards, I am using a gallery, connecting to SQL with selected fields displayed,  I want to submit the "selected values" when submitting the other calculations. I amusing Patch to do this and the calculations work but not the fields I have selected in the gallery.

'SPlistname':Value(fieldnameinPA_1.Text),

what am I missing here

Thanks

[WarrenBelz]

@mezcalbean 

What is your full Patch code and what in type of controls are your values contained in the gallery?

[mezcalbean]

Hi @WarrenBelz 

Patch(
AllSubmittedData,
Defaults(AllSubmittedData),
{
// this works for the calculation part
'SharePointcolumn1': Value(Label1_24.Text),
'SharePointcolumn2': Value(Label1_27.Text),
'SharePointcolumn3': Value(Label1_26.Text),
//this is the galery selected fields
'SPlistname':Value(fieldnameinPA_1.Text),

Writing this I realised I was trying to get a value which was incorrect. 

I changed to text from value and now no issue. 

'SPlistname':text(fieldnameinPA_1.Text),

Thank you if I wasn't getting the data for you I wold have missed it 🙂 ...again

[mezcalbean]

Hi @WarrenBelz 

Can I ask what I can have after : 'SPlistname': text/Value ?

'SPlistname':text(fieldnameinPA_1.Text),

 SO I can get a better understanding ?

Thanks

[WarrenBelz]

Hi @mezcalbean ,

Sorry a bit lost here - you are Patching to the List AllSubmittedData - the last line needs to refer to the (I assume) numeric field where the value is contained in the Text Control fieldnameinPA_1