Change the status of a column after sending an email

(0) Share

Report

Posted on by Claudio65

Hi everyone, and thanks in advance

I create a table in sharepoint (name, address,email ,mail,etc)

In power apps I create a gallery connected with the share point table and in each element, I have insert an email botton

now I send the mail but I don't know how update the "Mail" column with "Yes" after sending the mail.

"On select" (send emal button) I insert "office365outlook.sendemailv2" function and I send the mail but I don't know how to update the "MAIL" column in sharepoint with "YES".

I try with "Update" and "pacth" but I don't resolve, someone can help me

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

v-chengfen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Claudio65 ,
Do you mean while sending the email, update the sharepoint etc column to "YES"?
Could you please tell me the Etc column is the text column?
If yes, here is a test for your reference:
Here is list:

Office365Outlook.SendEmailV2(ThisItem.email,"Test","ThisItem.email");
Patch(Email,ThisItem,{etc:"Yes"})

Best Regards
Cheng Feng
Claudio65 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi before thank you for your answare,
I have a colomn in Sharepoint named "Mail" , when I send an email, I need to update the related colomn "Mail" in sharepoint with "YES"
Grazie
v-chengfen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Claudio65 ，
I'm sorry for my mistake to bother you。
Office365Outlook.SendEmailV2(ThisItem.email,"Test","ThisItem.email");
Patch(Email,ThisItem,{Mail:"Yes"})
Modify etc on the formula to Mail

Best Regards
Cheng Feng
Claudio65 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks for your support,
I think there are some problem with the syntax with commas and semicolons in english version and italian version
This is may scenario,
a gallery with an email icon for each item, when select the mail button navigate on "posta screen"

Now I can send the mail but i can't update the "mail inviata" field with "Yes"
ON SELECT (INVIA MAIL BOTTON)
Office365Outlook.SendEmailV2(TextInput2_1.Text;TextInput2.Text;RichTextEditor1.TEXT); Patch('Gestione Cellulari';thisitem;{'MailSpedita':"Yes")
I don't know if there is something else different between english e italian ...
Tks in adv
Buona serata
v-chengfen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Claudio65 ,
Could you please tell me that [Button] is inside [DataCard]?
If not, ThisItem will expire.

Best Regards
Cheng Feng
Claudio65 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi non it's outside I tray, to put the botton inside
fratrucc 86 on at

Like
a
(0)

Report
Copy link

Link copied!

Just try to put double ;; before the Patch function.
The Syntax it's like this in Italian.

Other than that, close the } if you had copy paste the code in the comment before.