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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

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.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,573)