SOLVED

Column value on SharePoint is Missing on Email

%3CLINGO-SUB%20id%3D%22lingo-sub-2216012%22%20slang%3D%22en-US%22%3EColumn%20value%20on%20SharePoint%20is%20Missing%20on%20Email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2216012%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20problem%20when%20I%20create%20new%20data%20on%20List%20SharePoint%20my%20value%20is%20Missing%20when%20email%20is%20send%20(using%20Email%20v2)%2C%20but%20when%20I%20test%20running%20using%20power%20automate%20test%20value%20is%20appear.%3C%2FP%3E%3CP%3ECan%20anyone%20help%20for%20this%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20email%20template%20on%20PowerAutomate%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Email%20Template.JPG%22%20style%3D%22width%3A%20601px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F264690i460BC152F074B0D7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Email%20Template.JPG%22%20alt%3D%22Email%20Template.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EValue%20on%20SharePoint%20List%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22SharePoint%20List.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F264693i56B73017ED5168DF%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22SharePoint%20List.JPG%22%20alt%3D%22SharePoint%20List.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEmail%20Received%20when%20create%20New%20on%20SharePoint%20List%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Email%20New%20list.JPG%22%20style%3D%22width%3A%20475px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F264691i27EDE826DB881185%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Email%20New%20list.JPG%22%20alt%3D%22Email%20New%20list.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETest%20Running%20using%20powerAutomate%20what%20I%20mean%20is%20like%20this%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Power%20Automate%20Testing.JPG%22%20style%3D%22width%3A%20313px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F264694iB6DF292E33315AEF%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Power%20Automate%20Testing.JPG%22%20alt%3D%22Power%20Automate%20Testing.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEmail%20when%20Testing%20using%20PowerAutomate%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Email%20Testing%20List.JPG%22%20style%3D%22width%3A%20431px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F264692iD636D81F2D6D2100%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Email%20Testing%20List.JPG%22%20alt%3D%22Email%20Testing%20List.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2216012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2216190%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20value%20on%20SharePoint%20is%20Missing%20on%20Email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2216190%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F999750%22%20target%3D%22_blank%22%3E%40lucas_ignatius%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20that%20column%20a%20calculated%20column%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2216297%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20value%20on%20SharePoint%20is%20Missing%20on%20Email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2216297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F774111%22%20target%3D%22_blank%22%3E%40Matti_Paukkonen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20that%20Calculated%20column%20but%20it%20only%20copy%20from%20another%20column.%3C%2FP%3E%3CP%3EEven%2C%20I'm%20using%20column%20single%20text%20it%20still%20not%20appear.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Calculated%20Column%20Order%20Number.JPG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F264727iAB54D2E540DBA3F0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Calculated%20Column%20Order%20Number.JPG%22%20alt%3D%22Calculated%20Column%20Order%20Number.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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

Email Template.JPG

 

Value on SharePoint List

SharePoint List.JPG

 

Email Received when create New on SharePoint List

Email New list.JPG

 

Test Running using powerAutomate what I mean is like this 

Power Automate Testing.JPG

 

 

Email when Testing using PowerAutomate

 

Email Testing List.JPG

 

 

9 Replies

Hi @lucas_ignatius 

 

Is that column a calculated column? 

@Matti_Paukkonen 

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

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

Calculated Column Order Number.JPG

can you help my problem?
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?
Referencing column is automatically generated because I'm using PowerAutomate for Generate Number.
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?

@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

PowerAutomate.jpg

 

best response confirmed by lucas_ignatius (Contributor)
Solution
What if you add Get Item SharePoint action before Send an email action, and use the Order Number value returned from that action.
Yeah...
I'm just using get item sharePoint it will be show my generate number.
Thanks