Column value on SharePoint is Missing on Email

[lucas_ignatius]

I've problem when I create new data on List SharePoint my value is Missing when email is send (using Email v2), but when I test running using power automate test value is appear.

Can anyone help for this problem?

My email template on PowerAutomate

Value on SharePoint List

Email Received when create New on SharePoint List

Test Running using powerAutomate what I mean is like this 

Email when Testing using PowerAutomate

[#2]

Hi @lucas_ignatius 

Is that column a calculated column? 

[#3]

@Matti_Paukkonen 

Yes, that Calculated column but it only copy from another column.

Even, I'm using column single text it still not appear.

[#4]

can you help my problem?

[#5]

Calculated column values are visible on emails in my environment.
Is the value of the column you are referencing with the formula added manually when the item is created?

[#6]

Referencing column is automatically generated because I'm using PowerAutomate for Generate Number.

[#7]

Okay. That is the issue because you cannot exactly know when PowerAutomate flow which updates the number is run. Can you use that same flow to send emails as well?

[#8]

@Matti_Paukkonen because my flow is using approval and if approve will be send email. And then I'm using update column on Order Number, not using Created column.

I Attached my flow, please help to check it

[#9 · Accepted solution]

What if you add Get Item SharePoint action before Send an email action, and use the Order Number value returned from that action.

[#10]

Yeah...
I'm just using get item sharePoint it will be show my generate number.
Thanks