web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / The right card id valu...
Power Automate
Answered

The right card id value which copy from SP list via flow in the excel

(0) ShareShare
ReportReport
Posted on by

Hi All, 

 

When i use my flow to copy the sp data and put it in excel, but the the ID card No doesn't show the right:

Harden-Y_0-1615528626087.png

 

Any helps is appreciated!

 

TKS,

Harden

Categories:
I have the same question (0)
  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    Hi @Anonymous 

     

    That's because the number is being converted to an exponential number in excel.  In order to prevent this from Power Automate, you can append an appostrophe to the start of the number and excel will treat it as text.  This would be exactly the same if you typed it into excel.

     

    So concat('''',Yournumber) in Power Automate.

     

    Make sure your concat has 4 apostrophes in the concact as an apostrophe has to be escaped by itself.

     

    Your number 1234567890 would therefore be '1234567890 and will display fine in excel.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien


    P.S. take a look at my new blog here

  • Community Power Platform Member Profile Picture
    on at

    Hi DamoBird365,

     

    Thanks for your reply.

    I tried the method you provided as below:

    Harden-Y_0-1615538376756.png

     

    But it still show the E+ value in my excel:

    Harden-Y_1-1615538419917.png

    Anything i missed.

     

    Thanks,

    Harden

     

  • Verified answer
    DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    Hi @Anonymous 

     

    Can you check the history of your run.

     

    Here is my test:

     

    DamoBird365_2-1615539385911.png

     

    And this is how they are inserted

     

    DamoBird365_3-1615539413900.png

     

    History shows the following:

     

    DamoBird365_4-1615539433374.png

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien


    P.S. take a look at my new blog here

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard