Unanswered

Patch Choice Field Not Working

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to patch to a SharePoint List with a Choice Column. It works throughout the rest of my app but the same code isn't working here for some reason.

The highlighted section is the part that wont work. I have a drop-down field called ApprovalNeededInput which pulls the options from the list just fine. Neither option will write to the list.

Patch('Retired Documents', Defaults('Retired Documents'),{Title: Text(RetiredTitleInput)}, {Reason: Text(RetiredReasonInput)}, {'Approval Required': ApprovalNeededInput.Selected}; {'Requested By':{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & RetiredRequesterInput.Selected.Mail,
Department: "",
DisplayName: RetiredRequesterInput.Selected.DisplayName,
Email: RetiredRequesterInput.Selected.Mail,
JobTitle: "",
Picture: ""
}}; {Approvers: ApproversCollection}, Form1.Updates)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Since this is tied to a form, this should all be in the form and a SubmitForm(Form1) should be all you need.

If there any particular reason to not do this? A problem you ran into by doing it perhaps?

What is the Items property of the ApprovalNeededInput control?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Its not tied to a form. I have an attachment field that shows up as a form element and adds attachments to the SPList item.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

If the attachments are intended for the datasource and record you are Patching, then it should all be part of the form and the SubmitForm function should be used.

But again - What is the Items property of the ApprovalNeededInput control?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

ApprovalNeededInput gets 2 choice options from the Approval Required column options in the SharePoint list.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

What is the formula on the Items property of the ApprovalNeededInput control?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Choices('Retired Documents'.'Approval Needed')

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

Okay...needed to make sure you were using that function - you had stated it got two choice options...made me think there was some filtering going on there.

Please consider changing your Formula to the following:

Patch('Retired Documents', Defaults('Retired Documents'), {Title: RetiredTitleInput.Text, Reason: RetiredReasonInput.Text, 'Approval Required': ApprovalNeededInput.Selected, 'Requested By': { Claims: "i:0#.f|membership|" & Lower(RetiredRequesterInput.Selected.Mail), Department: "", DisplayName: RetiredRequesterInput.Selected.DisplayName, Email: RetiredRequesterInput.Selected.Mail, JobTitle: "", Picture: "" }, Approvers: ApproversCollection }, Form1.Updates )

You have a variety of mismatched semicolons and commas in your posted formula, so I am not sure exactly what you have for the ApproversCollection.

You were also trying to convert a control to text i.e. Text(RetiredTitleInput)

You need to reference the control property that contains the value you want i.e. RetiredTitleInput.Text

And again, this should really be incorporated into Form1 and be done with a SubmitForm(Form1)

But, the above should get the basics working.

Was this reply helpful? Yes No