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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,587)