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
Unanswered

Power Automate Flow

(1) ShareShare
ReportReport
Posted on by 8

I m having trouble with my Power Automate Flow, hope you can help me

 

The thing is, I'm creating a dataframe consisting of 2 columns and keeping it empty.

 

Then, I do a for each loop and iterate through an excel so that if some conditions are met, I insert data into that dataframe.

I do this by selecting 2 columns from my excel to be saved in the dataframe but I get prompted an error that says something like: The number of values provided (1) do not match with the number of columns in the dataframe I believe Im not doing the insert rows right but I dont know how it should be done so that both values are stored in separate columns. Thank you very much in advance for your time. Best!

Categories:
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    Are you creating a dataframe using array variables?

     

  • Lydia2 Profile Picture
    8 on at

    No, we are creating an empty datatable with 2 columns, then inserting rows,but cant manage to insert values to each of the columns separately, we can only insert in the first column for some reason.

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    Screenshot of your flow?

     

  • Lydia2 Profile Picture
    8 on at

    Lydia2_0-1699363190651.pngLydia2_1-1699363207689.png

    Lydia2_3-1699363281692.png

     

     

  • Lydia2 Profile Picture
    8 on at

    Lydia2_0-1699374818227.pngLydia2_1-1699374828959.pngLydia2_2-1699374843981.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

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 302 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 263

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard