News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Get data from an attac...

Power Automate - Building Flows

Unanswered

Get data from an attached Excel file on an item and write it to specific Sharepoint fields

(0) Share

Report

Report

Posted on by TB-23101326-0

Can u explain me please how i set a flow for the following situations please:
If cell A1 in the attached Excel file on an item is modifief, take its value and transfer it to the fsharepoint field "Field A."
If cell B1 iin the attached Excel file on an item take its value and transfer it to the sharepoint field "Field B."

Categories:

Business Process Flows

All responses Img

All responses (1)

Answers Img

Answers (0)

Mark Nanneman 831 on at

Like (0)

Report

Get data from an attached Excel file on an item and write it to specific Sharepoint fields

Does your excel file have a table? Does each row have a unique identifier (either a number or GUID or some other ID or name that you're certain is never repeated?)

In general you need a table in your excel file to work with it in power automate.

If you don't have a table you can create one by saving the excel file in sharepoint and then creating a table on it using AI notation:

After that you'd just need to "list rows present" in the table

Then add logic to either look for the SharePoint item by a unique identifier shared by a cell in the excel table, or vice versa, and additionally some logic to determine if you want to update the sharepoint list based on the data in the excel file (some modified on date or something).

There are a number of ways to skin the cat on this one, using filters on your sharepoint and excel list rows actions, using power automates built in filter actions, apply to each loops, conditionals, etc.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 144,609

#2

RandyHayes 76,287

#3

Pstork1 64,420

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans