Adding, Updating or Upserting a Price List Item via Power Automate Error

(2) Share

Report

Posted on by Stephan J

I am trying to Upsert (Also does not work on Add or Update) a Price List Item and the required lookup field Price List is missing from the Action Please Help!

Results in Error:

 
  "error": {
    "code": "0x80043b12",
    "message": "The price level id is missing",
    "@Microsoft.PowerApps.CDS.ErrorDetails.HttpStatusCode": "400",
...
    "@Microsoft.PowerApps.CDS.InnerError.Message": "The price level id is missing"
  }
}

Categories:

Microsoft Dynamics CRM

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Nitesh Raj 188 on at

Like (0)

Report

From the description and Image, I can guess, You also have to fill the Price List column (fields) in the Create/ Update action. This column is required one.

---

Simply, get all (or just one) the price list items first, you will find the price list from it. copy and paste in the action. Remember when you use any lookup column you have to follow a format:
For example, opportunities( GUID) <-- for opportunity look up
(it your environment uses one then this method is fine)

Hope this helps you

Please consider approving the answer

Was this reply helpful? Yes No
Suggested answer

Tom_Gioielli 2,762 Super User 2025 Season 2 on at

Like (0)

Report
Price list items are the individual listing of a price for a product based on the price list. The required fields can change based on what pricing method you are using, but the following fields are always going to be required.

Lookup to Product {product}

Lookup to Price List {pricelevel}

Pricing Method option set

Lookup to Unit {uom}

Quantity Selling Option

And then whatever pricing method you determine have supporting fields (Amount if you select 'Currency Amount', Percentage if you selected a markup choice, etc.). Whenever doing something like this, I always recommend going into the application itself and creating a few records, so you have a sense of what is required before doing it through Power Automate.

Was this reply helpful? Yes No
Stephan J 23 on at

Like (0)

Report

Ahhh Hey @tom That might be the issue the Action doesn't show the required fields until I choose a pricing method.

Ill try that and report back for now I created a WebAPI call to do the upsert but that's not ideal as I have a dev production environments so going to be fund to switch them :-D

Was this reply helpful? Yes No
Stephan J 23 on at

Like (0)

Report

Its still an issue the Power Automate Upsert/Add or Update does not show the Price List field (PriceLevel) this looks like a bug to me ? any thoughts

Was this reply helpful? Yes No
Verified answer

Tom_Gioielli 2,762 Super User 2025 Season 2 on at

Like (1)

Report

That's really weird. I just checked in a test environment, and you are correct that the Price List is not an available option in the action. It also does not appear in the "Update a Row" action. Only the "Add a new row" gives it as an available option.

This is so specific it must be intentional. There must be something in the Price List Item table that prevents you from switching an existing record to a different price list. It may be due to the linked currencies or something else, but it looks to be deliberately disabled. I'm guessing you are going to need to update your flow away from the single "Upsert" action to instead have a check for whether it exists and create a branch to create new vs update.

Kind of a bummer, but the product/price tables are so old in CRM I'm not often surprised that these little things pop up to ruin our day.

If my answers helps, please consider marking as verified so other users can easily see them.

Was this reply helpful? Yes No