Answered

Excel Automation

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

update issue.PNG

Thanks,

Sai

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

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

Like (1)

Report
Copy link

Link copied!

Thank you very much @v-litu-msft .Code is working as excepted.

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

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No