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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Answered

Display Mode Help

(0) ShareShare
ReportReport
Posted on by 38

Dear community, I can't get my logic worked out on a DisplayMode formula. Any help is appreciated greatly.

 

If(ThisItem.Field1.Value = "Approved"  Or  ThisItem.Field2.Value = "No", disabled

 

BUT

 

If(ThisItem.Field1.Value = "Approved"  Or  ThisItem.Field2.Value = "No" And  User.Email = "John@email" Or  User.Email = "Jane@email", edit

 

BUT

 

If(ThisItem.Field1.Value <> "Approved"  Or  ThisItem.Field2.Value <> "No", edit

Categories:
  • JayMagness Profile Picture
    1,663 on at

    HI,

    Attached is the display modes syntax. 

    I will send you my contact information so maybe I can help personally.

     

    Edit form and Display form controls in Power Apps - Power Apps | Microsoft Learn

     

  • Verified answer
    HenWang Profile Picture
    Microsoft Employee on at

    Hi @jselman ,

     

    Guess you are trying to merge all of these three condition into one if condition, please try below formula:

    If(ThisItem.Field1.Value = "Approved" Or ThisItem.Field2.Value = "No" And User.Email = "John@email" Or User.Email = "Jane@email",
     edit,
     If(ThisItem.Field1.Value = "Approved" Or ThisItem.Field2.Value = "No", disabled, edit)
    )

     

    The above formula is just about the logic, please also remember to use ViewForm and Editform function to replace the edit and disabled word inside.

     

    Best Regards,

    Hen Wang

  • Verified answer
    jselman Profile Picture
    38 on at

    Thank Hen. I modified your solution by putting parenthesis around the grouped items and it worked perfectly.

     

    If((ThisItem.Field1.Value = "Approved" Or ThisItem.Field2.Value = "No") And (User.Email = "John@email" Or User.Email = "Jane@email"),
    edit,
    If(ThisItem.Field1.Value = "Approved" Or ThisItem.Field2.Value = "No", disabled, edit)
    )

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 405 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 368

#3
WarrenBelz Profile Picture

WarrenBelz 244 Most Valuable Professional

Last 30 days Overall leaderboard