Unanswered

Rich Text Editor in SharePoint list

(0) Share

Report

Posted on by biancadevera

I have a two SharePoint lists. One SharePoint lists has these columns: Ticket #, Status, Email Template (Rich Text Editor). My second SharePoint list has Status and Email Template columns. What I want to do is whenever I select Status (1st list) from my dropdown, it will get the email template set on the SharePoint list that I have.

Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @biancadevera

I have a few questions.

Is it email template is multi-line text in Sharepoint?
Do you want the email template updated from SP list 1 to SP list 2 on change on Status?
Status name is the key to connect/match both SP Lists

Was this reply helpful? Yes No
biancadevera on at

Like (0)

Report
Hi @StalinPonnusamy

Is it email template is multi-line text in Sharepoint? Yes
Do you want the email template updated from SP list 1 to SP list 2 on change on Status? It's vice versa. The list of email templates should be in SP list 2 then it will update the SP list 1
Status name is the key to connect/match both SP Lists? Yes

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @biancadevera

I recommend creating Power Automate for this scenario.
Trigger Based on SP List 1 Update
Get data from SP list 2 and Update SP list 1
This pattern will create an infinite loop. So we have to create one more field to make sure this update happens only one time
Create a new field in SP list 1 ( Called : UpdatedRequired, Type : Yes/No)
Using PowerApps, When you save the data, make sure to set Yes on this new field
Create Power Automate
Trigger: Scheduled Cloud Flow
Condition: When an Item is Modified or created
Update SP list with the new field to "No"
Your flow will look like this

Condition to avoid an infinite loop

Update Template and the field to No

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @biancadevera

Please let us know if anything needs on your post. We can help with this.

Please mark the post as Solved If I have answered your question.
Please give it a Thumbs Up if you find the suggestion helpful

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No