web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / invoice fetch based on...
Power Automate
Unanswered

invoice fetch based on order number in power automate

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi Team,

My question is :

From excel sheet i need to fetch order number and search in amazon or flipkart and send an email with the invoice to the customer who purchased it.

Please guide the flow.

Regards,
Shristy

 

Power Automate Community FAQ Microsoft Forms + Flow + Power BI @Anonymous automate

Categories:
I have the same question (0)
  • Krishna92 Profile Picture
    Microsoft Employee on at

    @Anonymous 

     

    Herewith, I am sharing you a few steps that you can follow to create your flow, this involves creating custom connector for communicating with API service.

     

    - For getting information from excel you can use pre-available excel connector

    - For searching information related to invoice and extraction of details you can use custom connector to get connected to Amazon API services.

    (https://docs.microsoft.com/en-us/connectors/custom-connectors/define-blank)

    - Once you have the response you can use Parse JSON action to parse the information that you get in the response.

    - Finally, you can use Send email action and include all the information required from Parse JSON action and send email.

     

    If this information helps you with resolution, please consider giving a thumbs up and mark the solution as resolved.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 459

#3
11manish Profile Picture

11manish 382

Last 30 days Overall leaderboard