Patch misses out one field

(0) Share

Report

Posted on by pricey79

340

Hello. Could anybody help me understand why this patch doesn't work correctly please?

Patch

('SharePoint List',First
(Filter(' SharePoint List',ID = ApprovalPage_Form.Selected.ID)) ,
{Status:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:1,Value:"Rejected",
'Reason For Rejection': ReasonForRejectionTextInput.Text}})
;

Office365Outlook.SendEmailV2(ThisItem.'Created By'.Email, "Form request has been rejected", "Hi" & "<br>" & "<br>" &
"Text " & Textbox.Text & " has been rejected due to: " & ReasonForRejectionTextInput.Text & ". Please address this issue before we can proceed with your request.")
;Reset(ReasonForRejectionTextInput)

It all patches fine, apart from the reason for rejection text input. The SharePoint column is set to text. It just doesnt bring that through in the first bit of code. It does come through with the send email part.

Any suggestions please?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
It looks like the rejection is part of the Status value. I moved one of the squiggly brackets, so give this a try:

('SharePoint List',First (Filter(' SharePoint List',ID = ApprovalPage_Form.Selected.ID)) , {Status:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:1,Value:"Rejected"}, 'Reason For Rejection': ReasonForRejectionTextInput.Text}) ; Office365Outlook.SendEmailV2(ThisItem.'Created By'.Email, "Form request has been rejected", "Hi" & "<br>" & "<br>" & "Text " & Textbox.Text & " has been rejected due to: " & ReasonForRejectionTextInput.Text & ". Please address this issue before we can proceed with your request.") ;Reset(ReasonForRejectionTextInput)

Was this reply helpful? Yes No
pricey79 340 on at

Like (0)

Report
Copy link

Link copied!

@Jeff_Thorpe
Thank you so much, that works now. Much appreciated

Was this reply helpful? Yes No