Skip to main content

Notifications

Power Automate - General Discussion
Answered

Excel "Get a row " wants key value but does not offer a property for that

(0) ShareShare
ReportReport
Posted on by 92

Hey folks,

 

just a quick question for understanding what power automate want me to do.... I just want get rows from my excel and I am using "get a row". There are properties to declare which excel where it is stored and which table within the excel I like to use. then I have do declare what the key column is. I did that....but when I like to test or to save the flow I am getting the error "key value is required" but I don´t have a property I can declare of "Key value".... WTF is going on? Someone any Idea?

 

AndreRadtke_0-1718610880410.png

 

  • Andre-Radtke Profile Picture
    Andre-Radtke 92 on at
    Re: Excel "Get a row " wants key value but does not offer a property for that

    Hi, thank you for this hint it helped:

    AndreRadtke_0-1718623375531.png

     

  • Verified answer
    Anil_g Profile Picture
    Anil_g 668 on at
    Re: Excel "Get a row " wants key value but does not offer a property for that

    @Andre-Radtke 

     

    Can you try closing and reopening it and then re add the get a row activity...as it should be showing in the properties

     

    Anil_g_0-1718611265790.png

     

     

    cheers

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard