cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FoDelement
Continued Contributor
Continued Contributor

Need help with string formatting

Hello all, I am trying to pass a string from powerapps to flow.

THIS

 

 

<form><select id=\"creditmemoglreq\" label=\"Credit Memo or GL Request\" mandatory=\"true\" style=\"combo\" type=\"string\" visible=\"true\">credit<option label=\"\"/><option label=\"Credit Memo\">credit</option><option label=\"GL Request\">glrequest</option></select><text button=\"4001\" id=\"usfcasscompany\" label=\"Company Vendor Name\" mandatory=\"true\" type=\"string\" visible=\"true\">BAY N GULF INC DBA SAVE ON SEAFOOD</text><text button=\"4002\" id=\"usfcasslocation\" label=\"Location\" mandatory=\"true\" type=\"string\" visible=\"true\">6L - North STAR-OKLAHOMA - 3180</text><text id=\"originalinvoice\" label=\"Original Invoice #\" mandatory=\"true\" type=\"string\" visible=\"true\">TEST</text><text id=\"invoicedate\" label=\"Invoice Date\" mandatory=\"false\" type=\"string\" visible=\"true\">22</text><text id=\"vendorcheck\" label=\"Vendor Check #\" type=\"string\" visible=\"true\">22</text><text id=\"usfcassamount\" label=\"Amount\" mandatory=\"true\" type=\"string\" visible=\"true\">22</text><text id=\"hpsmcase\" label=\"HPSM Case #\" type=\"string\" visible=\"true\">222</text><text id=\"po\" label=\"PO #\" type=\"string\" visible=\"true\">22</text><text id=\"creditmemo\" label=\"Credit Memo # (Required on Credit Memo)\" type=\"string\" visible=\"true\">222</text><text id=\"glaccount\" label=\"GL Account # (Required on CLEAR TO GL)\" type=\"string\" visible=\"true\">22222</text></form>

 

 

 
This is what I have in powerapps.

 

 

<form><select id=\" & Char(34) & "creditmemoglreq\" & Char(34) & " label=\" & Char(34) & "Credit Memo or GL Request\" & Char(34) & " mandatory=\" & Char(34) & "true\" & Char(34) & " style=\" & Char(34) & "combo\" & Char(34) & " type=\" & Char(34) & "string\" & Char(34) & " visible=\" & Char(34) & "true\" & Char(34) & ">credit<option label=\" & Char(34) & "\" & Char(34) & "/><option label=\" & Char(34) & "Credit Memo\" & Char(34) & ">credit</option><option label=\" & Char(34) & "GL Request\" & Char(34) & ">glrequest</option></select><text button=\" & Char(34) & "4001\" & Char(34) & " id=\" & Char(34) & "usfcasscompany\" & Char(34) & " label=\" & Char(34) & "Company Vendor Name\" & Char(34) & " mandatory=\" & Char(34) & "true\" & Char(34) & " type=\" & Char(34) & "string\" & Char(34) & " visible=\" & Char(34) & "true\" & Char(34) & ">BAY N GULF INC DBA SAVE ON SEAFOOD</text><text button=\" & Char(34) & "4002\" & Char(34) & " id=\" & Char(34) & "usfcasslocation\" & Char(34) & " label=\" & Char(34) & "Location\" & Char(34) & " mandatory=\" & Char(34) & "true\" & Char(34) & " type=\" & Char(34) & "string\" & Char(34) & " visible=\" & Char(34) & "true\" & Char(34) & ">6L - North STAR-OKLAHOMA - 3180</text><text id=\" & Char(34) & "originalinvoice\" & Char(34) & " label=\" & Char(34) & "Original Invoice #\" & Char(34) & " mandatory=\" & Char(34) & "true\" & Char(34) & " type=\" & Char(34) & "string\" & Char(34) & " visible=\" & Char(34) & "true\" & Char(34) & ">" & OrgianlInvoice.Text & "</text><text id=\" & Char(34) & "invoicedate\" & Char(34) & " label=\" & Char(34) & "Invoice Date\" & Char(34) & " mandatory=\" & Char(34) & "false\" & Char(34) & " type=\" & Char(34) & "string\" & Char(34) & " visible=\" & Char(34) & "true\" & Char(34) & ">" & InvoiceDate.Text & "</text><text id=\" & Char(34) & "vendorcheck\" & Char(34) & " label=\" & Char(34) & "Vendor Check #\" & Char(34) & " type=\" & Char(34) & "string\" & Char(34) & " visible=\" & Char(34) & "true\" & Char(34) & ">" & vendorCheck.Text & "</text><text id=\" & Char(34) & "usfcassamount\" & Char(34) & " label=\" & Char(34) & "Amount\" & Char(34) & " mandatory=\" & Char(34) & "true\" & Char(34) & " type=\" & Char(34) & "string\" & Char(34) & " visible=\" & Char(34) & "true\" & Char(34) & ">" & Amount.Text & "</text><text id=\" & Char(34) & "hpsmcase\" & Char(34) & " label=\" & Char(34) & "HPSM Case #\" & Char(34) & " type=\" & Char(34) & "string\" & Char(34) & " visible=\" & Char(34) & "true\" & Char(34) & ">" & HPSMCase.Text & "</text><text id=\" & Char(34) & "po\" & Char(34) & " label=\" & Char(34) & "PO #\" & Char(34) & " type=\" & Char(34) & "string\" & Char(34) & " visible=\" & Char(34) & "true\" & Char(34) & ">" & PONum.Text & "</text><text id=\" & Char(34) & "creditmemo\" & Char(34) & " label=\" & Char(34) & "Credit Memo # (Required on Credit Memo)\" & Char(34) & " type=\" & Char(34) & "string\" & Char(34) & " visible=\" & Char(34) & "true\" & Char(34) & ">" & creditMemoNum.Text & "</text><text id=\" & Char(34) & "glaccount\" & Char(34) & " label=\" & Char(34) & "GL Account # (Required on CLEAR TO GL)\" & Char(34) & " type=\" & Char(34) & "string\" & Char(34) & " visible=\" & Char(34) & "true\" & Char(34) & ">" & GLaccountNUm.Text & "</text></form

 

 

 

 

However, when it hits flow, it looks like this.

 

 

 

"Options": "<form><select id=\\\"creditmemoglreq\\\" label=\\\"Credit Memo or GL Request\\\" mandatory=\\\"true\\\" style=\\\"combo\\\" type=\\\"string\\\" visible=\\\"true\\\">credit<option label=\\\"\\\"/><option label=\\\"Credit Memo\\\">credit</option><option label=\\\"GL Request\\\">glrequest</option></select><text button=\\\"4001\\\" id=\\\"usfcasscompany\\\" label=\\\"Company Vendor Name\\\" mandatory=\\\"true\\\" type=\\\"string\\\" visible=\\\"true\\\">BAY N GULF INC DBA SAVE ON SEAFOOD</text><text button=\\\"4002\\\" id=\\\"usfcasslocation\\\" label=\\\"Location\\\" mandatory=\\\"true\\\" type=\\\"string\\\" visible=\\\"true\\\">6L - North STAR-OKLAHOMA - 3180</text><text id=\\\"originalinvoice\\\" label=\\\"Original Invoice #\\\" mandatory=\\\"true\\\" type=\\\"string\\\" visible=\\\"true\\\">123</text><text id=\\\"invoicedate\\\" label=\\\"Invoice Date\\\" mandatory=\\\"false\\\" type=\\\"string\\\" visible=\\\"true\\\">1/1/2020</text><text id=\\\"vendorcheck\\\" label=\\\"Vendor Check #\\\" type=\\\"string\\\" visible=\\\"true\\\">23123</text><text id=\\\"usfcassamount\\\" label=\\\"Amount\\\" mandatory=\\\"true\\\" type=\\\"string\\\" visible=\\\"true\\\">1.99</text><text id=\\\"hpsmcase\\\" label=\\\"HPSM Case #\\\" type=\\\"string\\\" visible=\\\"true\\\">123</text><text id=\\\"po\\\" label=\\\"PO #\\\" type=\\\"string\\\" visible=\\\"true\\\">123</text><text id=\\\"creditmemo\\\" label=\\\"Credit Memo # (Required on Credit Memo)\\\" type=\\\"string\\\" visible=\\\"true\\\">123</text><text id=\\\"glaccount\\\" label=\\\"GL Account # (Required on CLEAR TO GL)\\\" type=\\\"string\\\" visible=\\\"true\\\">123</text></form>"

 

 


Any idea why those extra backslashes appeared, and what I can do to prevent them?

Thanks! 

 

1 ACCEPTED SOLUTION

Accepted Solutions
FoDelement
Continued Contributor
Continued Contributor

The solution was to send the data without the backslashes at all. 

 

<form><select id=" & Char(34) & "creditmemoglreq" & Char(34) & " label=" & Char(34) & "Credit Memo or GL Request" & Char(34) & " mandatory=" & Char(34) & "true" & Char(34) & " style=" & Char(34) & "combo" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">credit<option label=" & Char(34) & "" & Char(34) & "/><option label=" & Char(34) & "Credit Memo" & Char(34) & ">credit</option><option label=" & Char(34) & "GL Request" & Char(34) & ">glrequest</option></select><text button=" & Char(34) & "4001" & Char(34) & " id=" & Char(34) & "usfcasscompany" & Char(34) & " label=" & Char(34) & "Company Vendor Name" & Char(34) & " mandatory=" & Char(34) & "true" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">BAY N GULF INC DBA SAVE ON SEAFOOD</text><text button=" & Char(34) & "4002" & Char(34) & " id=" & Char(34) & "usfcasslocation" & Char(34) & " label=" & Char(34) & "Location" & Char(34) & " mandatory=" & Char(34) & "true" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">6L - North STAR-OKLAHOMA - 3180</text><text id=" & Char(34) & "originalinvoice" & Char(34) & " label=" & Char(34) & "Original Invoice #" & Char(34) & " mandatory=" & Char(34) & "true" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & OrgianlInvoice.Text & "</text><text id=" & Char(34) & "invoicedate" & Char(34) & " label=" & Char(34) & "Invoice Date" & Char(34) & " mandatory=" & Char(34) & "false" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & InvoiceDate.Text & "</text><text id=" & Char(34) & "vendorcheck" & Char(34) & " label=" & Char(34) & "Vendor Check #" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & vendorCheck.Text & "</text><text id=" & Char(34) & "usfcassamount" & Char(34) & " label=" & Char(34) & "Amount" & Char(34) & " mandatory=" & Char(34) & "true" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & Amount.Text & "</text><text id=" & Char(34) & "hpsmcase" & Char(34) & " label=" & Char(34) & "HPSM Case #" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & HPSMCase.Text & "</text><text id=" & Char(34) & "po" & Char(34) & " label=" & Char(34) & "PO #" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & PONum.Text & "</text><text id=" & Char(34) & "creditmemo" & Char(34) & " label=" & Char(34) & "Credit Memo # (Required on Credit Memo)" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & creditMemoNum.Text & "</text><text id=" & Char(34) & "glaccount" & Char(34) & " label=" & Char(34) & "GL Account # (Required on CLEAR TO GL)" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & GLaccountNUm.Text & "</text></form>

View solution in original post

2 REPLIES 2
FoDelement
Continued Contributor
Continued Contributor

The solution was to send the data without the backslashes at all. 

 

<form><select id=" & Char(34) & "creditmemoglreq" & Char(34) & " label=" & Char(34) & "Credit Memo or GL Request" & Char(34) & " mandatory=" & Char(34) & "true" & Char(34) & " style=" & Char(34) & "combo" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">credit<option label=" & Char(34) & "" & Char(34) & "/><option label=" & Char(34) & "Credit Memo" & Char(34) & ">credit</option><option label=" & Char(34) & "GL Request" & Char(34) & ">glrequest</option></select><text button=" & Char(34) & "4001" & Char(34) & " id=" & Char(34) & "usfcasscompany" & Char(34) & " label=" & Char(34) & "Company Vendor Name" & Char(34) & " mandatory=" & Char(34) & "true" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">BAY N GULF INC DBA SAVE ON SEAFOOD</text><text button=" & Char(34) & "4002" & Char(34) & " id=" & Char(34) & "usfcasslocation" & Char(34) & " label=" & Char(34) & "Location" & Char(34) & " mandatory=" & Char(34) & "true" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">6L - North STAR-OKLAHOMA - 3180</text><text id=" & Char(34) & "originalinvoice" & Char(34) & " label=" & Char(34) & "Original Invoice #" & Char(34) & " mandatory=" & Char(34) & "true" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & OrgianlInvoice.Text & "</text><text id=" & Char(34) & "invoicedate" & Char(34) & " label=" & Char(34) & "Invoice Date" & Char(34) & " mandatory=" & Char(34) & "false" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & InvoiceDate.Text & "</text><text id=" & Char(34) & "vendorcheck" & Char(34) & " label=" & Char(34) & "Vendor Check #" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & vendorCheck.Text & "</text><text id=" & Char(34) & "usfcassamount" & Char(34) & " label=" & Char(34) & "Amount" & Char(34) & " mandatory=" & Char(34) & "true" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & Amount.Text & "</text><text id=" & Char(34) & "hpsmcase" & Char(34) & " label=" & Char(34) & "HPSM Case #" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & HPSMCase.Text & "</text><text id=" & Char(34) & "po" & Char(34) & " label=" & Char(34) & "PO #" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & PONum.Text & "</text><text id=" & Char(34) & "creditmemo" & Char(34) & " label=" & Char(34) & "Credit Memo # (Required on Credit Memo)" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & creditMemoNum.Text & "</text><text id=" & Char(34) & "glaccount" & Char(34) & " label=" & Char(34) & "GL Account # (Required on CLEAR TO GL)" & Char(34) & " type=" & Char(34) & "string" & Char(34) & " visible=" & Char(34) & "true" & Char(34) & ">" & GLaccountNUm.Text & "</text></form>

View solution in original post

RaashiSen
Community Support
Community Support

Thank you @FoDelement for sharing the solution as well 😊, glad it got addressed.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,829)