Answered

PROVIDE ITEM PROPERTIES IN EXCEL ONLINE

(1) Share

Report

Posted on by Community Power Pla...

Hello!

I am trying to build a flow that creates a copy of an excel file in share point, then, I want to update a row in this file that I created. I am using a dynamic file naming, meaning that I use an HTTP request to Sharepoint to search for the file.

The issue I am having is that, when I use the dynamic name in update a row, it asks for the item properties, and I don't know what to put in that field.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@Anonymous

Hey Mate,

It see you are using the Dynamic content in the *File, can you select the actual file and then try?

One of the reason for the he error that you are getting is because the column was deleted\does not exit from the excel file.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hey, @CFernandes

I already tried to use an actual file, and it worked, but for my flow, the file that I want to update the rows, doesn't exist yet, because it is the flow it's self that creates this file, and that's why there is dynamic content in the file name.

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (3)

Report

Hi!

Just guessing if same approach as with "Add a row into a table" can be applied also for "Update row"

https://powerusers.microsoft.com/t5/Building-Flows/Updating-an-excel-sheet-which-is-a-subject-of-my-Flow/m-p/528349#M67975

Hope this helps

Was this reply helpful? Yes No
myvsparth 31 on at

Like (5)

Report
If you having the parameter "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]" }

Reason for my problem with excel that I have used dynamic excel file name and table, in some cases you may have other reasons for this.
Thanks, Appreciate efforts if it helps you 🙂

Was this reply helpful? Yes No
enriquesanchez 13 on at

Like (0)

Report

You made my day!
Thank you very much.

Was this reply helpful? Yes No
mesut01 6 on at

Like (0)

Report

You are AWESOME!

Thank you so much!!!

Was this reply helpful? Yes No