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 / Automate order from Em...
Power Automate
Answered

Automate order from Email - Errors

(0) ShareShare
ReportReport
Posted on by 29
Trying to do the following:
Customer sends in an email to place a Sales Order (Dynamics 365), we will be going towards using power pages in the future

Email:
-- Created the queue etc no problem but the power automate flow is not working. (Dynamics Ciustomer Service Admin Center)
From the email, we just want the order to be created against the contact or the account, not interested in some fields as we'll manually enter that once the order is placed. We have a flow that sends a message via teams as the last step in the flow.

All the information in the body of the email will be put in the 'Description' field of the order

Firstly can this be done?
Please see the following screenshots of the flow and errors: 
 
PurchaseOrder9.png

Firstly, the following are required so I've tried to make them enter default values

Currency
Name - Using Subject
Price List (PriceLists)

This is what I want if possible:
'Currency' field: To be set with the default which is 'US Dollar'
Price List field: I want it to default to 'Automated Sales List' which is a price list we have
I created an expression
addProperty(variables('PriceLevelId'), item(), variables('Automated Sales Order'))
PurchaseOrder11.png

but it came back wit the following error:

Request to XRM API failed with error: 'Message: Flow client error returned with status code /BadRequest/ and details /{/error/:{/code/:/InvalidOpenApiFlow/,/message/:/Flow save failed with code 'InvalidVariableOperation' and message 'The inputs of workflow run action 'Create a record (don't rename this step)' of type 'OpenApiConnection' are not valid. The variable 'PriceLevelId' must be initialized before it can be used inside action 'Create a record (don't rename this step)'.'./}}/. Code: 0x80060467 InnerError: '

Any ideas or suggestions 

Regards
Rachel
Categories:
  • Verified answer
    pengwei Profile Picture
    139 on at

    Hi @RachelC 

     

    From the error message it can't allocate the variable "PriceLevelId". You need to initialize it before this step.

  • RachelColes Profile Picture
    29 on at

    Thank you for the help 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 425

#2
11manish Profile Picture

11manish 323 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard