Hi,
I have a manually created form(not the ready made form of powerapps). When user fill the field and clicks submit button,Task Status is shown as "New" for that user.
I want to send confirmation email to that user if Task Status is changed from "New" to "Completed".
How can i get that user's email when he/she submitted the form and how to send that user an email?
Can anyone give me a detailed solution regarding this?
Solved! Go to Solution.
Hi @MKMUMU :
Could you tell me what your data source is? Share Point? CDS?
Do you want to know how to get the email address of the creator of a record?
Do you want to know how to send that user an email if the Task Status is changed from "New" to "Completed"?
I assume your data source is Share Point list.( It has a system field "Created by", which records the information of the creator of the record)
I’ve made a test for your reference:
Here is my data source: List B
Column (click to edit) | Type |
Single line of text | |
Single line of text | |
Single line of text | |
Person or Group | |
Choice | |
Single line of text |
1\Add Office 365 Outlook as your data source.
View-Data sources-Connectors-Office 365 Outlook-Add a connection
2\ Put this code after your code which is used to change the task status:
If(
First(
Sort(
'List B',
Modified,
Descending
)
).'Task Status' = "Completed",/* Find the most recently modified item */
Office365Outlook.SendEmailV2(
First(
Sort(
'List B',
Modified,
Descending
)
).'Created By'.Email,/*Get the user’s email address*/
"Subject",/*the email’s subject*/
"Body"/*the email’s body*/
)
)
Best Regards,
Bof
Hi @MKMUMU :
Could you tell me what your data source is? Share Point? CDS?
Do you want to know how to get the email address of the creator of a record?
Do you want to know how to send that user an email if the Task Status is changed from "New" to "Completed"?
I assume your data source is Share Point list.( It has a system field "Created by", which records the information of the creator of the record)
I’ve made a test for your reference:
Here is my data source: List B
Column (click to edit) | Type |
Single line of text | |
Single line of text | |
Single line of text | |
Person or Group | |
Choice | |
Single line of text |
1\Add Office 365 Outlook as your data source.
View-Data sources-Connectors-Office 365 Outlook-Add a connection
2\ Put this code after your code which is used to change the task status:
If(
First(
Sort(
'List B',
Modified,
Descending
)
).'Task Status' = "Completed",/* Find the most recently modified item */
Office365Outlook.SendEmailV2(
First(
Sort(
'List B',
Modified,
Descending
)
).'Created By'.Email,/*Get the user’s email address*/
"Subject",/*the email’s subject*/
"Body"/*the email’s body*/
)
)
Best Regards,
Bof
thank You Bof....for your detailed guiding...really appreciate your help..😊
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
187 | |
81 | |
50 | |
38 |
User | Count |
---|---|
303 | |
249 | |
124 | |
73 | |
55 |