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

5 REPLIES 5
Super User III
Super User III

@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

Frequent 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 🙂

You made my day!
Thank you very much.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

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!

Users online (99,434)