Forum Discussion
Solved
Populating document library column value from on of the uploaded Excel file's cells (Possible?)
I've been trying to 'automate' a property column in a document library by having its value populated by each document added. To try to explain a little clearer: User adds document to the libr...
- Yeah just add a column: ROWID and for the row value in that column a 1 on your file exports. Then, you can just plug in ROWID for key column, and 1 for the key row. Then you will always get the value in the first row. Then for your value in the SharePoint action, you should have the BaselineTotal in the pick list from the "Get Row" section, you should see all your excel columns in there.
This basically would set your SharePoint column you put it in, to the first row of the document with the BaselineTotal value.
The filename part - awesome, you're teaching me a ton already, lol.
And yes, that would probably be easy enough to add the rowID (I'm presuming essentially that this is the key?). That makes sense, as you're right, it's always a single row in the table.
And yes, that would probably be easy enough to add the rowID (I'm presuming essentially that this is the key?). That makes sense, as you're right, it's always a single row in the table.
Yeah just add a column: ROWID and for the row value in that column a 1 on your file exports. Then, you can just plug in ROWID for key column, and 1 for the key row. Then you will always get the value in the first row. Then for your value in the SharePoint action, you should have the BaselineTotal in the pick list from the "Get Row" section, you should see all your excel columns in there.
This basically would set your SharePoint column you put it in, to the first row of the document with the BaselineTotal value.
This basically would set your SharePoint column you put it in, to the first row of the document with the BaselineTotal value.
- Thanks Chris! I think this all give me plenty to make this work. I really appreciate you taking the time to guide me in the right direction - you've been more than helpful!
Cheers!