cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

PROVIDE ITEM PROPERTIES IN EXCEL ONLINE

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. 

 

 

ajuda.png

1 ACCEPTED SOLUTION

Accepted Solutions

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

4 REPLIES 4
Resident Rockstar
Resident Rockstar

@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!

 

 

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.

 

1.png2.png3.png

 

 

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Regular Visitor

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]"
}

Provide-the-item-properties.png
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 🙂

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Top Kudoed Authors
Users online (8,028)