Power Platform Community Forum Thread Details

I have an PA flow triggered from Excel - with the flow pointing to the excel file

For the future i would want to use this flow over multiple excel files but cant see a way of doing this without creating multiple copy flows and pointing each one to an individual excel file

Is there an easy shortcut

Categories:

Using flows

Hi @Westport9 ,

I used below steps to achieve the mentioned requirement.

1. Create a cloud flow with trigger type as "When a http request is received". The request received should be of post type and it should have request body. The request body will have information regarding which excel has triggered the flow.

2. Create office script for each excel similar to below. This script when triggered will make http request to the power automate flow there by triggering the flow. We can add a button in excel for triggering this script. In request body the name(or identifier) of the excel is passed. In below script, excel1 is the identifier for the excel.

async function main(workbook: ExcelScript.Workbook) {

const response = await fetch('<Power Automate triggering url>', {

method: 'POST',

body: JSON.stringify({ x: "excel1"}),

headers: {

'Content-type': 'application/json; charset=UTF-8',

});

}

3. In power automate flow, get the excel identifier from the request body. Now we know which excel has triggered the flow. With this information we can point to that excel. For example, in below snapshot, I am using Switch condition to read the excel which has triggered the flow.