PROVIDE ITEM PROPERTIES IN EXCEL ONLINE

[JesusFernandes]

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. 

[CFernandes]

@JesusFernandes 

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!

[JesusFernandes]

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.

[efialttes · Accepted solution]

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-...

Hope this helps

[myvsparth]

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 🙂

[enriquesanchez]

You made my day!
Thank you very much.