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 (6)

Answers (0)

OkanMTL 703 Super User 2024 Season 1 on at

Like (0)

Report

You need to use a sharepoint activity to write into the columns within sharepoint. 🙂

Was this reply helpful? Yes No
JonMoore86 25 on at

Like (0)

Report

Thanks - I've tried to use the 'Update File Properties' activity but I don't see the output from the 'List Rows Present in a Table' activity... I only see the content from 'Create Table' or the 'When a File is Created (properties only)' activity.

Was this reply helpful? Yes No
OkanMTL 703 Super User 2024 Season 1 on at

Like (0)

Report

Use "Update item" or "Create item" activity

Was this reply helpful? Yes No
JonMoore86 25 on at

Like (0)

Report

I don't think I've explained my issue properly - When I come to update the properties of the record, I just don't see the table fields from within the Excel file so I can't update the properties with the values from this table.

Was this reply helpful? Yes No
OkanMTL 703 Super User 2024 Season 1 on at

Like (0)

Report

I see, thanks for the clarification.

You should use a Get tables activity after creating a table. This should create an apply to each loop, than use the List rows present in a table activity and use the dynamic table name you get from Get Tables activity.

Now this should retrieve values and you can use create item activities to pass values around to sharepoint.

Good luck.

Was this reply helpful? Yes No
JonMoore86 25 on at

Like (0)

Report

Thanks for your continued support! Do I need to use an expression to reference the fields within the table as even when I use the "get table" activity, I don't see the field names from my table - it runs happily using the dynamic table name from the "create table" expression, but I'm just unclear on how to reference the field names within the apply-to-each loop to update the item's properties....

Was this reply helpful? Yes No