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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Add Row Misses Data

(0) ShareShare
ReportReport
Posted on by 82

Hello,

I am adding rows into an Excel table based off values in a SharePoint list (passed through to flow with a json). When I add the rows, the values are displayed in the 'Row' field but don't show in 'Output'. As you can see in the example below, Region is populated in the 'Row' field but doesn't get displayed in the output body. It seems to be leaving off the lookup values. Can anyone help me resolve this issue? 

mglemser_1-1673906104663.png

 

mglemser_0-1673906359767.png

 

 

 

Categories:
  • Verified answer
    v-chengfen-msft Profile Picture
    Microsoft Employee on at

    Hi @mglemser ,

     

    I did some tests and I found that when the column names are inconsistent with the column names in excel, the same situation as you will occur.

     

    Here is excel

    vchengfenmsft_0-1674006636897.png

    Here is flow:

    vchengfenmsft_1-1674006767299.png

     

    Here is result:

    Test 1:
    The column name does not exist in excel, no value is filled

    vchengfenmsft_2-1674006903604.png

     

    Test 2:
    The column name does not exist in excel, fill in the value

     

    vchengfenmsft_3-1674006977204.png

     

    vchengfenmsft_4-1674007124761.png

     

     

    Here it is recommended to check whether the column names you fill in are consistent with those in excel

     

     

    Best Regards

    Cheng Feng

  • mglemser Profile Picture
    82 on at

    Thank you so much, Cheng, for helping me troubleshoot! Your solution was correct. The Excel table column names have to match the real SP list column names (change 'Translation ID Lookup:Title' to 'Translation_x0020_ID_x0020_Looku0'). Thank you!!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 298 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard