cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AliciaDG
Helper III
Helper III

Char (10) function not working

Hi,

 

I have an app that i am using for team to place their debrief notes for all the events we do. I have created an email function for them to be able to email the notes to themselves. 

 

I am using the Char(10) function to create lines between each question asked however when i click the send button it just emails the whole debrief note in one paragraph. Except for the last three questions those come out perfectly. Not sure what i am doing wrong. Also how do i code bold into the headings?

 

code is below

 

Office365Outlook.SendEmail(TextInput1,"Debrief Notes for: " & ThisItem.Title & "on " & ThisItem.'Date of Event',Concat('DARWIN EVENTS DEBRIEF NOTES',"Please find details below for: " & "Name of Event: " & ThisItem.Title & Char(10) & "Date of Event: " & ThisItem.'Date of Event' & Char(10) & "What worked well? " & ThisItem.'What worked well?' & Char(10) & "What can be improved? " & ThisItem.'What can be improved?' & Char(10) & "What can you add? " & ThisItem.'What can you add?' & Char(10) & "What could you have done without? " & ThisItem.'What could you have done without?' & Char(10) & "Suggestions for next event? " & ThisItem.'Suggestions for the next event?' & Char(10) & Char(10) & "Report entered by: " & ThisItem.'First & Last Name' & Char(10) & "Email address: "&ThisItem.'Email Address' & Char(10) & ThisItem.'What was your role?' & Char(10) & Char(10)))

email populates link below

 

Please find details below for: Name of Event: Christmas Eve Date of Event: 12/24/2019 What worked well? Chocolate and candy canes Overall look of foyer Christmas Characters in foyer What can be improved? Range of drinks on offer in Comma What can you add? Additional local elements during service Christmas Lights under our foyers Large Christmas Tree made from lights What could you have done without?

Suggestions for next event? Look at Christmas Brief earlier for local elements Delegate to Creative Moments oversight Christmas costumes for the car park team Confetti!!!

 

 

Report entered by: xxxxxxx

Email address: xxxxxxxx

Logistics Oversight

 

5 REPLIES 5
sayyed007amir
Resolver II
Resolver II

I use this code to break line in mobile device as well as in laptop for notification purpose.
But it may help you to achieve your goal.

 

Notify("Record already found on this date."& "<br>" & Char(13) & Char(10)&"Please select any other date !!",NotificationType.Error)

 

Thanks @sayyed007amir  where did you put that code in the powerapp itself? at the end of the code already created?

I used it on OnChange of Date picker, but you can use OnSelect of button and wherever you want to use for any action.

v-bofeng-msft
Community Support
Community Support

Hi @AliciaDG :

I've made a test but it worked well on my side ——

My formula:

Office365Outlook.SendEmail(User().Email,"Subject","A"&Char(10)&"B"&Char(10)&"C")

The Result:

2.JPG

I have two alternatives just for you to try:

Solution1:Replace Char(10) with Char(13)

Solution2:Use html tags to control line wrapping,the formula should be:

Office365Outlook.SendEmail(
   TextInput1,
   "Debrief Notes for: " & ThisItem.Title & "on " & ThisItem.'Date of Event',
   Concat('DARWIN EVENTS DEBRIEF NOTES',"Please find details below for: " & "Name of Event: " & ThisItem.Title & "</br>" & "Date of Event: " & ThisItem.'Date of Event' & "</br>" & "What worked well? " & ThisItem.'What worked well?' & "</br>" & "What can be improved? " & ThisItem.'What can be improved?' & "</br>" & "What can you add? " & ThisItem.'What can you add?' & "</br>" & "What could you have done without? " & ThisItem.'What could you have done without?' & "</br>" & "Suggestions for next event? " & ThisItem.'Suggestions for the next event?' & "</br>" & "</br>" & "Report entered by: " & ThisItem.'First & Last Name' & "</br>" & "Email address: "&ThisItem.'Email Address' & "</br>" & ThisItem.'What was your role?' & "</br>" & "</br>"),
   {IsHtml:true}
   
)

Best Regards,

Bof

Hi @v-bofeng-msft,

 

apologies for the delay i had to put this project down for a bit but back on it. the code above worked well.

 

cheers 🙂 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

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.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,382)