Using data from multiple Excel cells in Power Automate Flow

(0) Share

Report

Posted on by ceesrijkaart

Hi All,

I'm working on a system for registrating non-conformities, submitted via Forms, into a sharepoint list.

When an item in the list is created, the contents of the list are also saved into an Excel file, which forms the report of the issue.

This all works perfectly.

Now, I'd like to have both the form and the sharepoint list updated if the other source of information is modified.

Updating the Excel list triggered by a modification in the sharepoint list is easy, I'm struggling with the other way around.

Since a modified file in a sharepoint folder is not a trigger, I'm using a sequenced flow. My plan is to have a script in the Excel file running for each file in the specific folder.

Could anybody help me out with a script code, that reads data from specific cells a worksheet, and making them available as variables in the Power Automate flow?

Thanks a lot!

All responses (2)

Answers (1)

ceesrijkaart 6 on at

Like (1)

Report

Re: Using data from multiple Excel cells in Power Automate Flow

Hi @v-wenjuan-msft

Thanks for the great help, that is indeed the perfect trigger for this situation, especially with the modified conditions.
FYI: I've succesfully written the script. The code is:

function main(workbook: ExcelScript.Workbook){

  let Form_sheet = workbook.getWorksheet("Sheet1");
  let idValue = Form_sheet.getRange("E2").getValue();
  let Authorname = Form_sheet.getRange("B2").getValue();
  return {idValue, Authorname}

}

In Power Automate, I've add the Sharepoint Modify Item action. The returned parameters idValue and Authorname from the Excel script can be used in this action.
Verified answer

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Re: Using data from multiple Excel cells in Power Automate Flow

Hi @ceesrijkaart ,

I don't play with script... but SharePoint connector do have a trigger named "When a file is created or modified (properties only)" which may match your request.

You can set trigger condition to this code to limit the flow just triggered when modifications happened rather than creation.

@not(equals(triggerBody()?['Created'], triggerBody()?['Modified']))

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community site session details

Using data from multiple Excel cells in Power Automate Flow

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Using data from multiple Excel cells in Power Automate Flow

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates