Using data from multiple Excel cells in Power Automate Flow

[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!

[v-wenjuan-msft · Accepted solution]

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.

[ceesrijkaart]

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.