News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Flow connecting excel ...

Power Automate - Building Flows

Answered

Flow connecting excel with HTTP API followed by excel output

(0) Share

Report

Report

Posted on by Sportynick

15

Hi all,

Currently have a HTTP node that is able to connect to an API via post request.

Issue is that only one item is checked each time as a script is typed { "Name": "ABC", "Number": "12345A" } into the input body for checking and expected results are received in output body.

Which nodes should be connected to do batch checking of data?

Intent is to get data from rows stored in two columns (i.e. Name, Number) in an excel file on OneDrive. Results from output body will then be nicely fitted to a new worksheet in the same excel file (perhaps 1 line per input row checked).

Thanks in advance for helping.

Categories:

Business Process Flows

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

ChristianAbata 8,949 Most Valuable Professional on at

Like (2)

Report

Re: Flow connecting excel with HTTP API followed by excel output

hi @Sportynick what you need to do is get your http output response when runs well and then use it to parse json, after that you are going to be able to use every data inside your response see

In my example I'm using the output compose response, just imagine that ir your json http response.

You can see this video https://www.youtube.com/watch?v=eSwdxAJQmJU&t=3s to learn how to use apis.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans