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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automate order from Em...
Power Automate
Unanswered

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:
I have the same question (0)
  • Verified answer
    pengwei Profile Picture
    139 on at
    Re: Automate order from Email - Errors

    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
    Re: Automate order from Email - Errors

    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard