Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

JSON items not all passing into excel tabel

(0) ShareShare
ReportReport
Posted on by 69

I have a flow that sort of works. 

 

Basically when a user clicks a button in Power Apps it will run a flow where data from a Data Table will be passed into a new table on a new worksheet in excel.  My problem is that the account number and the applied columns which have things in it for both my test runs don't pass the data.  Any ideas what's going on?

 

Acruz5_2-1712597907654.png

 

Result:

Acruz5_1-1712597750680.png

 

I'm not sure what the problem is, as my data did pass through in my compose step.

Acruz5_3-1712598133718.png

 

However in the add row step the Account Number and Applied data drop off in the Outputs and I don't know why.

 

Acruz5_4-1712598337123.png

 

  • Acruz5 Profile Picture
    69 on at
    Re: JSON items not all passing into excel tabel

    That worked! It's always the misspelling. 

  • Verified answer
    abm abm Profile Picture
    32,472 Most Valuable Professional on at
    Re: JSON items not all passing into excel tabel

    Hi @Acruz5 

     

    Check you mappings are correct or not for those values which are missing? Under the Add row actions step check the peek code to make sure your mapping are correct. Check the spellings?

     

    image.png

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >