Patch choices column in SP list on form submit button

[lg270492]

Hi all,

Hoping one of you clever people can help me 🙂 

I am launching a form via my gallery then I have a submit button for a form and when the button is clicked, I would like to patch the value 25 to my choices column in SP List. I have the current code which throws out no errors but doesn't reflect the patched value in my list: 

Patch('SO and STO Tracker - Starchy', OTBGallery_SSE.Selected,{'Shipment Status':{Value:"25"}});
SubmitForm(OTB_Form_SSE);
Notify("You have sucessfully submitted this form for item "& TextInput1_5.Text & " . Sharepoint is updated",NotificationType.Success);
Reset(TextInput1_5);
Reset(TextInput1_7);
UpdateContext({OTBBlkVar:false})

Any advice would be greatly appreciated here!

Thanks in advance all!

[ANB · Accepted solution]

Hi @lg270492 , Can you try this:

Patch('SO and STO Tracker - Starchy', 
LookUp('SO and STO Tracker - Starchy', ID = OTBGallery_SSE.Selected.ID),
{'Shipment Status':{Value:"25"}});

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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

Thanks,
ANB

[lg270492]

Hey @ANB,

Thank you for your swift response! Unfortunately I still dont see the value patched to my SP list 😞 

Any ideas why? 

Thanks again your support is appreciated

[ANB]

@lg270492 Can confirm that you have 25 as one of the choice in SP choice column? Can you share screenshot: Example: I have CO as choice column in my SP and I have below sets of choices as shown below

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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

Thanks,
ANB

[lg270492]

Hi, 

Yes I can confirm that 25 is a choice in the column, see screenshot below: 

[ANB]

@lg270492 What is the items property of gallery OTBGallery_SSE? Also check whether for your below code. Does the Items property of gallery is showing data from SP list? Because this is pretty straight forward: Please check this https://www.matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/p...

Thanks,

ANB

[lg270492]

@ANB my gallery is filtered on multiple collections I have set. See one of the examples here: 

If(
drpLoc.Selected.Value = "BOZ, NL",
Filter(
OutboundCollectionSSE,
(drpLoc.Selected.Value = "All" || 'Shipping Plant Name'.Value = drpLoc.Selected.Value),
(IsBlank(TextInput1_5.Text) || TextInput1_5.Text in 'Blackout Order #'),
(IsBlank(TextInput1_7.Text) || TextInput1_7.Text in 'TC2 FOR#'),
(IsBlank('Net Weight')),
('Shipment Status'.Value <> "99"),
('Shipment Status'.Value <> "80"),
('Shipment Status'.Value <> "85")
),

Could this be the reason why the patch function is not working? I cant see that being the case but I am no expert by any means 🙂 

[ANB]

@lg270492 Does collection OutboundCollectionSSE  and this SP list 'SO and STO Tracker - Starchy' both has any relationship?

Because if you see the code that I suggested, we are getting the ID from gallery.selected. so ID from OutboundCollectionSSE and 'SO and STO Tracker - Starchy' should be same.

How OutboundCollectionSSE collection is created, Does this collection has ID column?

Thanks,

ANB

[lg270492]

The collection is created onstart of the app. 

I create 4 different collections (per location name - in this case BOZ) based on some parameters coming from the SP list (not sure if this is the best way to do that but it works and the app functions haha). See my example here of the collection creation: 

ClearCollect(
/*BOZ*/
OutboundCollectionSSE,
Filter(
'SO and STO Tracker - Starchy',
'Shipping Plant Legacy'.Value = "4400132" Or 'Shipping Plant Legacy'.Value = "4400609" Or 'Shipping Plant Legacy'.Value = "4400545" Or 'Shipping Plant Legacy'.Value = "9110485" Or 'Shipping Plant Legacy'.Value = "4400485" Or 'Shipping Plant Legacy'.Value = "4400361" Or 'Shipping Plant Legacy'.Value = "4400581" Or 'Shipping Plant Legacy'.Value = "4400321" Or 'Shipping Plant Legacy'.Value = "9110485" Or 'Shipping Plant Legacy'.Value = "9110621" Or 'Shipping Plant Legacy'.Value = "4400622"
)
);

As for your question regarding the collection containing the ID column, how do I go about checking that?

Thanks again and sorry If I am asking stupid questions

[lg270492]

I can confirm that the collection does indeed have the ID field the same as the SP List. I added the field in the gallery and I can see it correlates with that in the SP list.