Patch Fails with Office365Outlook

(0) Share

Report

Posted on by Rob1990

Hi,

I am trying to send email using 'Office365Outlook.ReplyToV3' I have passed in:

Message ID
To
Subject
Body
Mailbox Address

My looks like below:

Office365Outlook.ReplyToV3(Last(Filter(MessagesTable,Ticket.'Messages ID'=CurrentMessage.'Messages ID')).'Message ID',
{To:MainTable.'Raised By'.'Primary Email',
 Subject:Last(Filter(MessagesTable,Ticket.'Ticket ID'=CurrentMessage.'Ticket ID')).Subject,
 Body:TextInputCanvas2.Value,
 mailboxAddress:CurrentUser.'Primary Email'});

When I use this, sends the email no problem, however when I then go to patch the sent message to a Dataverse table I then get the error...

When I go into Dataverse table this record and all the fields have been filled out correctly however when I go into the button there is error lines over the 'Office365Outlook.ReplyToV3'.

The email does not get sent, but the data appears inside Dataverse, also in the code the patch is after sending the email.

Can anyone shed some light on why this code would work on it's own but doesn't when adding the patch function after inside the on select inside a button

Thanks

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

TuongDoan 573 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I believe this filter function returned blank result.

Last(Filter(MessagesTable,Ticket.'Messages ID'=CurrentMessage.'Messages ID')).'Message ID'

You have to add more condition to make sure it's not blank before passing the parameter to the function

--------------------------
If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs up would be a great compliment!
Rob1990 42 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TuongDoan,

That's what I thought so I did but the code into a text label to see the value and it did return the message ID Value...

Last(Filter(MessagesTable,Ticket.'Messages ID'=CurrentMessage.'Messages ID')).'Message ID'

It's strange that this only fails when adding the patch function afterwards, If I remove the patch to Dataverse it works and sends the email.

I also tried this with 'Coalesce' but this didn't work either...

Coalesce(Last(Filter(MessagesTable,Ticket.'Messages ID'=CurrentMessage.'Messages ID')).'Message ID')

Thanks