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!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
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.

Was this reply helpful? Yes No
ceesrijkaart 6 on at

Like (1)

Report

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.

Was this reply helpful? Yes No