0

Here is the screenshot of the source and destination:

Here is the screenshot of the source and destination:1. I am working on a flow which updates a column SME Comment CK on the basis of another column SME Comment. These columns are multiline text. but when the column gets updated I can see the html tags in it. How can I update the column as it is in SME Comment. PFA the screenshot for reference.enter image description here

  1. Also, I have another column resource name which has data in the format - Patrick_Jay, Eric_D_Dsouza. I want these to be updated in another column Resource email id in the [email protected], [email protected]. This not need to be via flow. is this possible in sharepoint?
Improve this question

1 Answer 1

Reset to default
1

Screenshot of flow:

enter image description here

Screenshot of Result:

enter image description here

Screenshot of Sharepoint list columns:

enter image description here

  1. See screen shot from Power automate how to copy multiline (not sure how you managed to get the html tags in there!). I am assuming here that you are not using http request to update the columns. Here we are copying the multilines from the column Source to the column Target.

enter image description here

enter image description here

  1. You can make the Resource email id a calculated column and put in the following formular:

=IF(ISBLANK([resource name]), "", [resource name]&"@gmail")

this will append the "@gmail" to the resource name or leave the field empty if resource name field is empty.

Improve this answer
9
  • Hello @RuneBH, thank you so much for your response! :) ohh it got resolved now. Earlier the source column was an enhanced rich text and destination column was a plain text. corrected it to enhanced rich text. But now I have another issue. I have a condition in flow where it checks if the source column is equal to the destination column then send an email. but it always results as false.
    – HRY
    Commented Nov 4, 2020 at 9:49
  • Hi @HRY After updating the destination column you need to get file properties again and use those in the condition as it will otherwise not have the updated properties. That might be the issue :)
    – RuneBH
    Commented Nov 4, 2020 at 11:05
  • 1
    That would be Get Item.
    – RuneBH
    Commented Nov 4, 2020 at 11:18
  • 1
    I just tried it out with a source column with line breaks, different font colors, indents etc. It will copy just fine and the condition result set to "true". Perhaps post a screen shot of your flow :)
    – RuneBH
    Commented Nov 4, 2020 at 11:40
  • 1
    Perhaps try to create a list element and manually insert a value in both columns in order to verify that you condition works. If it does then it must be something in your copy columns values that are not working. If this is the case I would check that columns are indeed of the same type and with same settings. If this is looking alrite then I would check if your flows (I sense that perhaps there are multiple flows running on the list) are not interfering with each other.
    – RuneBH
    Commented Nov 4, 2020 at 13:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.