News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Error when trying to u...

Power Automate - Building Flows

Suggested answer

Error when trying to update a row in an excel file on sharepoint

(1) Share

Report

Report

Posted on by patty2904

14

I'm trying to build a flow that will allow the removal of the data in G to K (see below), if the date in row K is more than 6 months ago. This file is stored on the sharepoint:

I get the error: Action 'Update_a_row' failed: The 'inputs.parameters' of workflow operation 'Update_a_row' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'id' Can anyone see what is happening?

Here is my flow:

Here is my compose:

Here is my filter array:

Here is apply to each:

and update a row:

Categories:

Business Process Flows

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Pstork1 66,968 Most Valuable Professional on at

Like (0)

Report

Error when trying to update a row in an excel file on sharepoint

There needs to be one column in your Excel Table that is unique for each row. I don't think you can use the Last Strike Date column as the Key column since it isn't always going to be unique.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 566 Super User 2025 Season 1

#2

David_MA 516 Super User 2025 Season 1

#3

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans