Unanswered

Displaying and retrieving values to display for SendEmailV2

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good day all. I have encountered an issue where I have patched a value in a column and tried to retrieve to use it in my email body after. The SharePoint row is updated with the newest value through Patch function, however, when I tried to retrieve it, it retrieves the old value instead.

I have thought about giving it more time to Patch before sending the email through Timer function. However, it seems like that is not the issue. I've researched and it seemed like there is something about how the application 'retrieves' the latest data values from the database, and not update it until I refresh the application or so, any advice would be appreciated.

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

To retrieve the latest value, I think you could add a Refresh() function before the Office365Outlook.SendEmailV2.

In addition, if you use a Timmer to send out the email, you should note that some properties within the Timmer maybe affect the operation that you retrieve the column value.

To solve this delay issue, just add a Refresh(ListName)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft,

Thanks for your reply. I have tried to refresh the list, however, the email sent still does not contain the latest value.

For instance,
As I click on Approve, the SharePoint list column gets updated with the value 'Notes Updated', however, the email I receive, retrieves the previous value, in this case, displaying value 'Notes Original'.

Another thing to note is that, even if I try to update the Notes value from 'Notes Updated' to 'Notes Updated 2', the value retrieved in the email will not be 'Notes Updated' but will show 'Notes Original'. I wonder if it's something to do with how PowerApps fetch the data values.

Thanks.
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

Could you please tell me that how you set this varRecord?

Actually, the variable you store the record maybe not be refreshed. Every time you send the email, you shoule trigger the variable again.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-qiaqi-msft,

This is set in order to give the case a unique ID to be saved into the database, so that when I update a request, the correct row is updated. I set it through the gallery from another screen.

May I know what do you mean by triggering the variable again?

Thank you!!!
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

I mean the formula you create the variable, post the whole formula.

I mean refreshing the variable.

Please give more details about your scenario, like your Patch() function, all of this could be a clue.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft,

I use the varRecord to store the variable of the specific role in the SharePoint list so that I'm able to update and patch a specific row based on its ID.

That is how I make use of the varRecord variable. Regarding the Patch() function,

this is how I patch the particular column 'Approver 1 Notes' using the TextInput1, which is basically a text box.

Thank you.