Unanswered

Update document properties from Excel

(0) Share

Report

Posted on by 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! Table_in_Excel .png

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

HenWang Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
JonMoore86 25 on at

Like (0)

Report

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

Was this reply helpful? Yes No