Unanswered

How to print a row with new line character from excel to teams

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have a table in microsoft excel which generates a string in the output table in A15 cell, this piece of string contains a new line character ie char(10).

Now I have created a flow which reads this table and post it on one of my channel on teams, the problem is that the the new line character is totally getting discarded in the process and the entire string comes as one line in the messege, Is there any fix to this issue.

I have added my flow below

This is how I get the Output using flow:

but this is what I really want:

I looked at the output of the test run but everything looks fine in here and I am unable to pin down the issue

Any suggestion or help guys..

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-bacao-msft on at

Like (2)

Report
Hi @Anonymous ,

Please try to use this method.

Initialize a string variable and hit the Enter key in Value.

Then use the replace() function to replace the carriage return in Output with <br>.

Expression reference:

replace(item()['Output'],variables('Enter'),'<br>')

Image reference:

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

Hi @v-bacao-msft ,
The Table name is: Table2
I had a similar requirement maybe you can help me with this.
The scenario was as follows: I have an excel file which looks like this
In Power Apps using the attachments control I am uploading this excel file and then using Power Automate I am storing this data in a SharePoint List named RegisterationData
The only issue that I am facing the new line character is getting discarded like EmployeeId:14567 has 2 qualifications associated with them BTech, HSC (similarly for instituteName, GradeType,PrimarySkills) but only the first row value is getting stored, so using the expression that you have mentioned above (as it was for the entire table in my case the table is divided into columns how can I use the expression in my flow for these columns that can multiple values separated on a new row)

My flow is as follows:
Did add the variable as you suggested:
So initially this is the flow how it looks where in I have mapped the values directly from list rows action (and once set I have changed the file properties to be dynamic as you can see in the initial images using expressions)

If I want to consider the new line values how to add them for the respective object
Like EmployeeId: 14567 should only have 2 qualifications stored with them which is BTECH, HSC (and the next qualification BCom should be associated with the EmployeeID: 2315 not the previous one - I guess this is taken care by Apply_to_each as it is correctly associated)

Please let me know how to proceed, if you need more information I have posted my query in Power Apps forum as well the link to which is: Query

Hope to get your reply

Regards,
Sidhant.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

Hi @v-bacao-msft ,
I did try to use your expression in the create item fields so I am able to get the values as shown in excel
(Just for the dates column added this expression: if(empty(items('Apply_to_each')?['StartDate']),null,items('Apply_to_each')?['StartDate'])
And now I am getting the values as shown in excel.
Now in gallery I want to show the records based on the representation like the Employee ID: 14567 has 2 qualifications (that includes qualification name, institute name, grade system) projects (Project name, Description, start date, end date, Role, Client name)
So currently the new row is treated as new value itself instead I want it to be associated with the previous record and only create a new record when the first two fields are filled in like Id, email)

If you have any idea on how to proceed do let me know,

Regards,
Sidhant

Was this reply helpful? Yes No