Power Platform Community Forum Thread Details

I have a Sharepoint list with enable attachment , and using Canvas App for creating records and uploading attachments into it.
depending on different approval stage/status, user can approve attachments .
Addition for every creation/modification to the list there is approval flow running , so I can't use two patch function to modify same record.
This below patch function is not working as required.
Basically I want to patch couple of field values like , Status(choice column),NameofBank(choice),Comment(multiline htmltext) and upload multiple attachments into same record
Patch(

RequestForIssueBG,

varRecord,

{

Status: {Value:"Issued"},

NameoftheBank: {Value: DataCardValue16.Selected.Value},

GuaranteeNo: DataCardValue13.Text,

ExpiryDate: DataCardValue14.SelectedDate,

Whetherextendedearlier: {Value: DataCardValue15.Selected.Value},

ApprovalComments: varRecord.ApprovalComments & " " & varRecord.Status.Value & " Remark : " & Remarktxt.Text,

ApprovalLogs: varRecord.ApprovalLogs & " " & varRecord.Status.Value & ": BG issued on " & Text(

Now(),

"dd-mm-yy hh:mm"

) & " by " & Office365Users.UserProfileV2(User().Email).displayName & "; " & "Comment : " & Substitute(

Remarktxt.Text,

".",

//& " " & varLastSubmit.ApprovalLogs,

RequestStatus: {Value: "Approved"}

}//,BankGuaranteeform.Updates //add attachment here

);Patch(RequestForIssueBG,varRecord,{},BankGuaranteeform.Updates)

Also I tried

Patch(

RequestForIssueBG,

varRecord,

{

Status: {Value:"Issued"},

NameoftheBank: {Value: DataCardValue16.Selected.Value},

GuaranteeNo: DataCardValue13.Text,

ExpiryDate: DataCardValue14.SelectedDate,

Whetherextendedearlier: {Value: DataCardValue15.Selected.Value},

ApprovalComments: varRecord.ApprovalComments & " " & varRecord.Status.Value & " Remark : " & Remarktxt.Text,

ApprovalLogs: varRecord.ApprovalLogs & " " & varRecord.Status.Value & ": BG issued on " & Text(

Now(),

"dd-mm-yy hh:mm"

) & " by " & Office365Users.UserProfileV2(User().Email).displayName & "; " & "Comment : " & Substitute(

Remarktxt.Text,

".",

//& " " & varLastSubmit.ApprovalLogs,

RequestStatus: {Value: "Approved"}

},BankGuaranteeform.Updates)
But this patch function doesn't update Choice field and multi line html text field

Expert please help me with it.

Categories:

Building Power Apps

Hi @apeawakening ,

I cannot see a lot wrong with that code - which field names are not updating and is the rest working ? You can try this in the meantime

Patch(
 RequestForIssueBG,
 {
 ID: varRecord.ID,
 Status: {Value: "Issued"},
 NameoftheBank: {Value: DataCardValue16.Selected.Value},
 GuaranteeNo: DataCardValue13.Text,
 ExpiryDate: DataCardValue14.SelectedDate,
 Whetherextendedearlier: {Value: DataCardValue15.Selected.Value},
 ApprovalComments: varRecord.ApprovalComments & "<br>" & varRecord.Status.Value & " Remark : " & Remarktxt.Text,
 ApprovalLogs: 
 varRecord.ApprovalLogs & "<br>" & varRecord.Status.Value & ": BG issued on " & 
 Text(
 Now(),
 "dd-mm-yy hh:mm"
 ) & " by " & User().FullName & "; " & 
 "Comment : " & 
 Substitute(
 Remarktxt.Text,
 ".",
 ""
 ),
 RequestStatus: {Value: "Approved"}
 },
 BankGuaranteeform.Updates
)

Also can you please set out the field types on each item

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.

MVP (Business Applications) Visit my blog Practical Power Apps