Answered

Using Combo Box to Patch text input to SharePoint + Submit Form

(0) Share

Report

Posted on by amac_ncheese

Hi all,

I'm a newbie to apps, so excuse me if I don't quite understand what I'm supposed to be doing. I've created a Form attached to a SharePoint list. I've got a datacard from a SharePoint choice field ("product number"), and I'd like to accept text input in the event the product number isn't listed.

I've watched Shane Young's video here on how to accomplish that. However, I don't have a gallery to update like he does in the video, so I'm confused as to how to write the code simplt to get text input from the datacard to sharepoint. I've included a snip of the code from his video.

Thanks in advance for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 154,411 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @amac_ncheese ,

Try this on the Button OnSelect

Patch( Employees, {ID:Gallery1.Selected.ID}, { 'Favorite Color': {Value:ComboBox1.SearchText} } )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
amac_ncheese 36 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

I don't have a gallery. I just a form within the app (pictured below), so what would the ID be to update SharePoint and the Form

Was this reply helpful? Yes No
Ashwin7104 671 on at

Like (0)

Report
Copy link

Link copied!
Hey @amac_ncheese ,

If the SharePoint form is an edit form, use SharePointIntegration.Selected.ID to get the ID. If there is no ID in case of new form, please use Defaults(DataSource).

Patch(DataSource,Defaults(DataSource),...)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,411 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@amac_ncheese ,

It should be

Patch( Employees, {ID:SharePointIntegration.SelectedItemID}, { 'Favorite Color': {Value:ComboBox1.SearchText} } )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No