web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Update row in excel, ...

Power Automate

Answered

Update row in excel, can't find column name on advanced parameters

(0) Share

Report

Report

Posted on by 郁邱-16120821-0

9

Hi all,
I have a problem with PA flow when selecting an action, "Excel online for business" and then choising "Update row".

If using file browser to choice File location and Sheet data, it work fine.

But passing parameters to apply into "File location" && "Sheet data", i can't find name of column in advanced variables.

Is this possible to using variable applying or a limitation of this action ?

Please reply , sincerely thanks.

(*) ACTION post :

User's image

User's image

User's image

Categories:

Using connectors

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

郁邱-16120821-0 9 on at

Like (1)

Report
Copy link

Link copied!
Solved.

"Provide the item properties" with required field that means power automate doesn't recognize the schema of your input so you need to provide input in JSON format. for eg.

{ "[Column Name]": "[Value]", "[Column Name]": "[Value]", "[Column Name]": "[Value]" }

Was this reply helpful? Yes No

Join the conversation