Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

invoice fetch based on order number in power automate

(0) ShareShare
ReportReport
Posted on by

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

  • Krishna92 Profile Picture
    Krishna92 on at
    Re: invoice fetch based on order number in power automate

    @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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard