How to Display Contract-Specific Sales Prices in SharePoint Lists

Open your target SharePoint project pricing list, click the Settings gear icon in the top right corner, and select List settings.

Scroll down to the Columns section. Click on your existing lookup column, or click 'Create column' to build a new lookup column connecting to your contract price list.

In the column settings page, scroll down to the section labeled 'Add a column to show each of these additional fields'.

Check the box next to the 'Sales Price' field. You can also select any other hierarchy level fields you need to display.

Click 'OK' to save. The sales price will now automatically display as a linked column alongside your primary lookup value in the list view.

Navigate to your SharePoint list, click 'Integrate' in the command bar, hover over 'Power Automate', and select 'Create a flow'.

Choose the trigger 'When an item is created or modified' and connect it to your project pricing list.

Add a 'Get item' action to fetch the specific contract and hierarchy values from your source contract list based on the lookup ID.

Insert a 'Condition' control to evaluate your specific rules (e.g., if SellOutLevel equals Level 1).

In the 'If yes' branch, add an 'Update item' action. Map the calculated price to a standard Number or Currency column in your project list, then save and test your flow.