cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Get Quote line details like price, quantity of a specific quote

Hi, 

 

I'm trying to create a flow when a quote is updated and meets a specific condition. i want to get all the items in the quote line and their details, create an html table of the items to send in an email.

 

something similar to the steps below, but i need some guidance as i'm new to power automate.

 

Capture.PNG

another try:

 

Capture.PNG

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Post Prodigy
Post Prodigy

Re: Get Quote line details like price, quantity of a specific quote

Hi @khedir ,

 

It should be _quoteid_value eq guid

 

Thanks

View solution in original post

6 REPLIES 6
Highlighted
Post Prodigy
Post Prodigy

Re: Get Quote line details like price, quantity of a specific quote

Hi @khedir ,

 

You are on right track . Please follow the url to help you format the HTML table and send it as email :

 

https://spmaestro.com/handling-json-in-microsoft-flow/

 

Thanks

Highlighted
Regular Visitor

Re: Get Quote line details like price, quantity of a specific quote

dear @ManishJain 

 

i'm getting the following error on list items:

 

A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.CRM.quote' and 'Edm.Guid' for operator kind 'Equal'.

 

changed it to the guid, still same thing

Highlighted
Regular Visitor

Re: Get Quote line details like price, quantity of a specific quote

quoteid is a look up field for the quote, which means it contains the guid, changed the identifier to quote since it returns a guid.

 

i got the following error:

 

A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.CRM.quote' and 'Edm.Guid' for operator kind 'Equal'.

Highlighted
Post Prodigy
Post Prodigy

Re: Get Quote line details like price, quantity of a specific quote

Hi @khedir ,

 

It should be _quoteid_value eq guid

 

Thanks

View solution in original post

Highlighted
Regular Visitor

Re: Get Quote line details like price, quantity of a specific quote

@ManishJain 

 

thank you!!

Highlighted
Microsoft
Microsoft

Re: Get Quote line details like price, quantity of a specific quote

@ManishJain Thank you for your response.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (5,797)