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>
RaashiSen
Community Support
Community Support

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

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,100)