Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Yes or No and Not Applicable

(0) ShareShare
ReportReport
Posted on by 112

Hi !

Did anyone could help in the following, many Thanks !

Wanna to have one more choice in the field selection : 

1. Yes or No and Not Applicable 

2. can only move to other field if Yes or Not Applicable is chosen

Appreciate your help.

Thanks

Har Har

 

pastedimage1684148659808v1.png

  • Suggested answer
    Eiken Profile Picture
    Eiken on at
    RE: Yes or No and Not Applicable

    Hi,

    Did my answer help you ?

    If yes, please don't forget to click Yes under "Did this answer your question?" to close this thread.

  • Suggested answer
    Eiken Profile Picture
    Eiken on at
    RE: Yes or No and Not Applicable

    Hi,

    Without Javascript, you can use Business rule to hide the field or lock the field.

    Now I have created a choice type field called "Test choice" and add it to the form.

    Create a new business rule.

    pastedimage1684202490844v1.png

    Set the condition "Test choice does not contain data ", and you can hide or lock other fields.

    pastedimage1684202620923v2.pngpastedimage1684202828664v3.png

    Remember to click Apply after edit each action. Then click save and active this business rule.

    pastedimage1684202882004v5.png

    My logical are as follow.

    IF

    Test choice does not contain data

    THEN
    Hide field Parent
    Lock sub-files
    Lock test field
    ELSE
    Show field Parent
    Unlock sub-files
    Unlock test field
    Then it works.
    pastedimage1684203287563v6.pngpastedimage1684203296757v7.png

  • HarHar Profile Picture
    HarHar 112 on at
    RE: Yes or No and Not Applicable

    ok thanks a lot, let me hare a try.

  • Guido Preite Profile Picture
    Guido Preite 54,069 Super User 2024 Season 1 on at
  • HarHar Profile Picture
    HarHar 112 on at
    RE: Yes or No and Not Applicable

    thanks for quick reply.

    save record first is ok.

    could you please advise how to do it ?

    Appreciate your great help.

    Thanks

    Har Har

  • Guido Preite Profile Picture
    Guido Preite 54,069 Super User 2024 Season 1 on at
    RE: Yes or No and Not Applicable

    not in real time. You can use business rules but it will require to save the record first, with javascript you can perform the logic in real time as soon the user change the value inside the form

  • HarHar Profile Picture
    HarHar 112 on at
    RE: Yes or No and Not Applicable

    Thanks for quick reply.

    Any other alternative way to do instead of javescript ?

    Thanks

    Har Har

  • Guido Preite Profile Picture
    Guido Preite 54,069 Super User 2024 Season 1 on at
    RE: Yes or No and Not Applicable

    you will need some javascript to the onchange event to check the values

    https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/client-scripting

  • HarHar Profile Picture
    HarHar 112 on at
    RE: Yes or No and Not Applicable

    oic...

    let me have a try

    How about question 2. can only move to other field if Yes or Not Applicable is chosen

    How to control the field to move to other field or action ?

    Appreciate your help.

  • Guido Preite Profile Picture
    Guido Preite 54,069 Super User 2024 Season 1 on at
    RE: Yes or No and Not Applicable

    you need to create a new field

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,791 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans