Update document properties from Excel

[JonMoore86]

Hi all,

Struggling to work out what to do next here...  I've got a flow where I need to update 4 property fields in a SharePoint document library for an excel file as soon as it is uploaded. 

So far, I've got the trigger to run as soon as a new file is uploaded, access the excel file and create a 2 column, 4 row table (5 with headers) which contains the data I need.  I then run the 'list row present in a table' step to get all of the data I need.

Next step - I need to know how to enter the 4 pieces of data into the corresponding property fields... when I try to run an apply-to-each using the output from 'list rows...' I do not see the field names from my table.  Clearly I've missed a step or I'm going about this the wrong way - can anyone lend a hand?

Many thanks in advance!

[HenWang]

Hi @JonMoore86 ,

To get the field names from your table, you need to create table in below way:

Then you will have these for field and put inside the dynamic content from SharePoint list.

BR,

Hen Wang

[JonMoore86]

Thanks so much for your response - unfortunately the data is already laid out vertically by my user as below - is there no way of extracting the rows as they currently stand?  Maybe I could put them into a variable or something like that?

Project Name:	Jon Test Project
Project Number :	JT001
Review for Period:	MAY-23
Financial Year:	23-24