You’re offline. This is a read only version of the page.
Hi team,
I want to update a row in excel table dynamically where flow is fetching the filename dynamically from SharePoint location using the SharePoint connector.Here the problem is as I am getting the filename dynamically so no data comes from drop down.So I am creating the variables and passing through each fields but there is 3 important fields to update the row i.e Key Column and Key Value,Item.I am able pass the unique key column and values to Key Column and Value field but may I know What should I pass in Item?
For Example consider the below sample table
| Id | Name | Marks |
| 1 | Raj | |
| 2 | Ram |
I want update the marks column dynamically in different excel files uploaded in SharePoint. Here Filename is dynamic,Table name to constant for every file and ID is unique column I am passing the key column and key value through variables but not sure what should I pass in Item Field and What is Syntax .Suggest me to solution what exactly I need to give in Item field in below screen to update the row.
Appreciate for the help as I helps in complete one Project
Thanks,
Sai
Hi @Anonymous,
I am trying to do a very similar thing. I want to be able to copy all rows from selected file (uploaded to SharePoint twice a day) and copy them to the Master tracker. Would you be able to help me understand how you are creating variables and fetching data from columns in the selected file to transfer them to another file?
Karo_S
Hi @Anonymous,
Use JSON format could do it, for example:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,948
Most Valuable Professional
Share
Report
All responses (
Answers (
