Answered

Update SharePoint list items with Excel

(1) Share

Report

Posted on by michalt1

I am struggling to build this seemingly simple flow. I have an existing SharePoint list that already has data and one of the columns is blank (UPS tracking number). I need to pull a .CSV file from UPS of shipments (i.e. tracking numbers) where each tracking number will have a corresponding reference # that is also found in the SP list. I just need the UPS .CSV file to update the SP list with those tracking numbers in the correct row. I've looked around at other solutions and found ones that look to sync these or to create a list item from the .xls or .csv files but not this specific flow. Can anyone help me please??

SP list.png

Here is what I have tried based on flows I copied but obviously getting it wrong.... circled where I know there are issues because I didn't know what to insert...

Screenshot 2023-03-21 122738.jpg

Screenshot 2023-03-21 123052.png

Screenshot 2023-03-21 123403.jpg

Categories:

Business Process Flows

All responses (15)

Answers (1)

michalt1 52 on at

Like (0)

Report

Re: Update SharePoint list items with Excel

using excel so not sure the issue 😞
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Update SharePoint list items with Excel

Hi @michalt1

Yes you can only use this for Excel files.

Thanks
michalt1 52 on at

Like (1)

Report

Re: Update SharePoint list items with Excel

Set it up exactly that way and still showing an error. Does it matter if CSV vs excel?
Verified answer

abm abm 32,464 Most Valuable Professional on at

Like (1)

Report

Re: Update SharePoint list items with Excel

Hi @michalt1

I can see you your worksheet name is some sort of id?

=OFFSET(040423023-456879123!A1,0,0,SUBTOTAL(103,040423023-456879123!$A:$A),3)

Open the excel file and find out. Thought it should be a name.

This worked for me.
michalt1 52 on at

Like (0)

Report

Re: Update SharePoint list items with Excel

Awesome tip! Ok I added this action before creating the table but not got this error at the "create table" stage:

The argument is invalid or missing or has an incorrect format.
clientRequestId: fc418816-008e-431b-a97a-303d2028e597
serviceRequestId: 6f070652-e543-4369-bc63-e67fbc78cc45;624b73b3-697b-421d-921c-93b8b68fbf9c

I modified the table range to include that variable (maybe that was wrong?)

Here is the raw input for table range when I tested it (I see it did pull the name of the particular worksheet I added):

=OFFSET(040423023-456879123!A1,0,0,SUBTOTAL(103,040423023-456879123!$A:$A),3)
abm abm 32,464 Most Valuable Professional on at

Like (1)

Report

Re: Update SharePoint list items with Excel

Hi @michalt1

Solved: How to get excel worksheet names in a list variabl... - Power Platform Community (microsoft.com)

Once you get the worksheet name then pass this as a variable substitution in your formula.

Thanks
michalt1 52 on at

Like (0)

Report

Re: Update SharePoint list items with Excel

Each time I download data from UPS.com the sheet is named something different (that day’s date + other characters) 😉
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Update SharePoint list items with Excel

Hi @michalt1

You don't need to rename the "Sheet1". Change the formula to use your sheet name.

Thanks
michalt1 52 on at

Like (1)

Report

Re: Update SharePoint list items with Excel

Sorry for my delay as I was OOO. I figured out the first part creating the table and realized I needed to rename the tab on my Excel to "Sheet1" for this to work (I am downloading the CSV from an external source so it's automatically named something else). Struggling a bit to make this work for my specific use case but will keep playing around here.
abm abm 32,464 Most Valuable Professional on at

Like (1)

Report

Re: Update SharePoint list items with Excel

Hi @michalt1

Above for the List rows present in a table > For setting the Table name, place the cursor under the text box and click custom value and enter 'TrackingDetails'