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 Platform Community / Forums / Power Automate / Flow Bugs Create a Row...
Power Automate
Unanswered

Flow Bugs Create a Row in Excel / Columns in excel in middle of table are not present

(0) ShareShare
ReportReport
Posted on by 184

Hey,

 

I get identified Documents from AI Builder and Create a new row in Excel with the results.

In Flow Action there are missing 3 Columns and i dont know why.

As you can see Column "E" is the last displayed in Flow Action and than "I" is the next Column in Flow Action.
So there are 3 Columns missing in Flow action but why ? Nothing is locked or similar.

Build in Old Designer.

 

Any Ideas?

HansenvomDeich_1-1715546537847.pngHansenvomDeich_2-1715546557143.png

 

 

 

 

Categories:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @HansenvomDeich 

     

    Did you refreshed the excel file ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • HansenvomDeich Profile Picture
    184 on at

    Hi @Nived_Nambiar ,

    thanks for you Answer ...  that was a blast , failure by myself (see below) ? 

    For that views i screenshoted, the Columns are in there since hours. So there is nothing "new" or something like that.

    When i Edit the Flow, the Columns are there and the one i need is filled with its value from parse json.

     

    HansenvomDeich_0-1715588052082.png

    HansenvomDeich_1-1715588295236.png


    Fail in my Flow:
    In the Key String from Compose Json and Parse Json there is an "n" which is not comparing.

     

     

     

     

     

     "AN Nachn": @{		if (
    			empty(
    				outputs('Extract_information_from_documents')?['body/responsev2/predictionOutput/labels/AN_0020Na80860e68f74f29991a44460ac6333fe/text']
    			),
    			String('fehlt'),
    			Replace(
    				Replace(
    					Replace(
    						Replace(
    							Replace(
    								outputs('Extract_information_from_documents') ? ['body/responsev2/predictionOutput/labels/AN_0020Na80860e68f74f29991a44460ac6333fe/text'],
    								'/', ' '
    							),
    							'.', ' '
    						),
    						',', ''
    					),
    					'(', ' '
    				),
    				')', ' ')
    		)
    	},
     "AN Nach": {
     "type": "string"
     },

     

     

     

     

     

    Strange is that:
    Input in  ParseJson , Black Line is Customername

    HansenvomDeich_2-1715606702461.png

    Parse JSON Schema (missing "n" at the end in Schema)

    HansenvomDeich_3-1715606771459.png

    Output of Parse JSON (Black Line is Customername , same as input)

     

    HansenvomDeich_5-1715606870066.png


    i didnt get focused on that json script and parse json, i believe that i get a failure in parse json if the Keys to the Value are wrong, so that i get a failure in Parse Json Action.
    Also what confusing is for me ... that i get the right string back in output of parse json.

     

    and I wouldn't have found the error if I hadn't taken screenshots for you to show you the problem 😉

     

    anyway, thank you very much for trying to help me, I really appreciate it

     

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 468

#2
Haque Profile Picture

Haque 370

#3
Valantis Profile Picture

Valantis 354

Last 30 days Overall leaderboard