News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Excel Power Automate

Power Automate - Using Flows

Unanswered

Excel Power Automate

(0) Share

Report

Report

Posted on by Westport9

2

Hi

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Kapil775 25 on at

Like (1)

Report

Re: Excel Power Automate

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.

Thanks!

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,668 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans