cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mezcalbean
Helper II
Helper II

Selected Value from Gallery submitting to Sharepoint

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

 

4 REPLIES 4
WarrenBelz
Super User
Super User

@mezcalbean 

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

mezcalbean
Helper II
Helper II

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
Helper II
Helper II

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

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

Announcements
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.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

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.

PA.JPG

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
Top Kudoed Authors
Users online (1,746)