Unanswered

SharePoint List: Read values from Excel attachments and input them back into the List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I'm very new to Power Automate but my office is looking to use it for some urgent business needs. We have a SharePoint List where people add new manifests and input all the relative information for them, and then attach a manifest document (usually xlsx) to each item in an "Attachments" column. The issue is that some people have not been filling in all the columns on the List; however, the attached manifest document sometimes have the info that is missing. I want to know is it possible to make a flow that will:

Filter the SharePoint List by certain conditions (ex. Customers = AA, Load # = "Empty")
Based on those filters, open the "Attachments" column and open the manifest Excel file
Read a value based on the column name (ex. Load = 3, 4, 5)
Input that value back into a SharePoint column (ex. now the Load # Column has 3, 4, 5 for Customer AA)

I've only ever done a basic automatic email flow, so I was wondering is it even possible for Power to read from Excel attachments like I mentioned? How would I connect it to a certain column in the SharePoint connector? Any help or guidance is appreciated

Categories:

Process mining

I have the same question (0)

All responses (4)

Answers (0)

Sort by

manuelstgomes 6,643 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Let's do it step-by-step.

Can you please share your initial Flow so that we can work from there?

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Manuel thank you for the reply,
So I'm starting off with a manual flow since filling in the missing info won't be caused by any automated trigger - Just checking for any blanks each week. Then I start off connecting to the SharePoint Site "For a selected item." There are several lists in the site for each location - would I have to make separate flows for each of them? The next step is where I get lost because I want to make sure it's first filtered by certain conditions, and not sure which block would do that

Was this reply helpful? Yes No
manuelstgomes 6,643 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Here's a skeleton of what you need.

There's only one detail. Since you don't know the Excel path (it's in the attachment), you need to use the strategy here to open a file from a dynamic path. Use the "Full Path" that you can find in the Attachment details.

Here's a tutorial on how to open an Excel in a dynamic path:

https://manueltgomes.com/microsoft/powerautomate/how-to-access-dynamic-path-excel/

And there's the skeleton:

Can you please check if and let me know if you have any questions?

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Manuel,

I have a similar problem and I was trying out your solution however I am stack in the part of File Path and the Table.
I read your guide on how to get Excel's dynamic path but I am not sure how this is possible with an attachment from a list.
Could you please explain how can we can intergrade this step into this "main" flow?
In my case by the way I don't even need to limit my excel by column and I just want to create a new item in a Sharepoint List, not update one with the content from the Excel file.

Was this reply helpful? Yes No