Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Selected Value from Gallery submitting to Sharepoint



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.


what am I missing here




Super User
Super User


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

Helper II
Helper II

Hi @WarrenBelz 


// 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

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


I changed to text from value and now no issue. 


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



Helper II
Helper II

Hi @WarrenBelz 


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


 SO I can get a better understanding ?



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

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (3,037)