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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Solution to show Multi Contract names and their statuses

(0) ShareShare
ReportReport
Posted on by 57

I would love to be able to show multi-contract names and their respective statuses in the header.

Here's a mockup of what I'm thinking:
pastedimage1674674741179v4.png

As you can see above, I have three contract types (Blue, Red, and Yellow). I would like to have a quick visual (I'm thinking the header is the best place) to see the contract name and the status. Can you tell me how I could achieve this?


I have the same question (0)
  • Suggested answer
    Abdul Wahab Profile Picture
    12,119 Moderator on at

    Hi emilu,

    Basically, if I am not wrong, It is a header. You need a single line of text column with some logic to populate it as per your needs. Put that column in the header.

    To manipulate logic you can use one of the below as per your needs

    1. Power Automate
    2. Plugin
    3. Workflow extension
    4. e.t.
  • emilu Profile Picture
    57 on at

     Abdul Wahab Can you be more descriptive with steps on how to achieve that?

    Here's an example of what I mean by helpful steps:

    If using make.powerapps....

    1.  In make.powerapps you will need 3 columns (for each contract) with the choice data type. (the choices will be the status)
    2.  In your header, you will ....

    OR

    If using powerautomate...

    1.  In powerautomate...
  • Pradeep Rai Profile Picture
    5,489 Moderator on at

    Hi,

    I would suggest to create one option set field (Choice) in dynamic CRM. which will have 3 values as Blue, Red, Yellow and based on Status you can update this field value using business rule as shown below:

    pastedimage1674759732117v1.png

    CRM UI:

    pastedimage1674759872747v3.png

    One more suggestion is you can add PCF control on form for better UI as shown in above screenshot:
     

  • emilu Profile Picture
    57 on at

    Pradeep Rai You're out here doing the Lord's work. Out of all the questions I've asked on the forums in the past months, yours has been the first to actually be helpful!

  • Pradeep Rai Profile Picture
    5,489 Moderator on at

    Thank you so much.

  • emilu Profile Picture
    57 on at

     Pradeep Rai Though, How can I show multiple contracts and their respective statuses in the header? This is what the user wants.

  • Pradeep Rai Profile Picture
    5,489 Moderator on at

    Sorry i miss understood requirement.

    You have 1:N relationship with contract? which means there can 4,5,6  any number of contracts will be created by users

  • emilu Profile Picture
    57 on at

    Pradeep Rai 
    Currently, I only have one type of contract.
    ....However, we are negotiating a couple of new contract types. So, with these new additional contract types the user wants to have a quick visual on the Contact header - of the contract type (red, blue, yellow) and what their status is (active, inactive, suspended, onboarding...)

    Like this mockup I made:
     pastedimage1674761821272v1.png

  • Pradeep Rai Profile Picture
    5,489 Moderator on at

    Thank you for details.

    How do you stores the contract types and status.

    It is in entity as a one row.

    or Inside field storing these values.

  • emilu Profile Picture
    57 on at

    Pradeep Rai 
    Currently: Since I only have one type of contract, it's just a column with the contract name (the data type is choice) and the choices are the statuses. But I'm assuming with the new contracts depending on the type of solution that will work best - I may have to deprecate that column and re-enter the data for those contracts. Does that make sense?

    I wouldn't get too caught up in how I am currently handling it -- I'm looking for a future solution.

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Pallavi Phade Profile Picture

Pallavi Phade 98

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 36 Super User 2025 Season 2

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans