DisplayMode formual error

[Jeffrey_H]

this is in my DisplayMode for this button.

After SCode))) there's a comma that is red and underlined and give me an error message.

It's weird since it actually does what it's intended but what would be the fix for this error ?

______________________________________________________________________

__________________________________________________________________________

DisplayMode = 

If(!IsBlank('sbox-Student_ID'.Text) && !IsBlank(gal_StudentID) && Len('sbox-Student_ID'.Text) = 7 &&
!IsBlank(LookUp('Student Thank You Cards for Donors',('sbox-Student_ID'.Text) = Student_ID)),

!IsBlank('sbox-SCode'.Text) && !IsBlank(gal_SCode) && Len('sbox-SCode'.Text) = 9 &&
!IsBlank(LookUp('Student Thank You Cards for Donors', ('sbox-SCode'.Text) = SCode))),

DisplayMode.Edit, DisplayMode.Disabled))

[SpongYe · Accepted solution]

Hi @Jeffrey_H 

Try this code:

DisplayMode = 
If(
    (!IsBlank('sbox-Student_ID'.Text) && !IsBlank(gal_StudentID) && Len('sbox-Student_ID'.Text) = 7 && !IsBlank(LookUp('Student Thank You Cards for Donors',('sbox-Student_ID'.Text) = Student_ID))) 
    || 
    (!IsBlank('sbox-SCode'.Text) && !IsBlank(gal_SCode) && Len('sbox-SCode'.Text) = 9 && !IsBlank(LookUp('Student Thank You Cards for Donors', ('sbox-SCode'.Text) = SCode))),
    DisplayMode.Edit, 
    DisplayMode.Disabled
)

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

[Jeffrey_H]

Sorry to say that did not work.  It stays greyed out and will not shift into edit mode.

[v-jefferni]

Hi @Jeffrey_H ,

Apparently, the formula has parenthesis at wrong places. Please try below formula instead:

If(
    (
        Len('sbox-Student_ID'.Text) = 7 &&
!IsBlank(LookUp('Student Thank You Cards for Donors',Student_ID ='sbox-Student_ID'.Text))
    )
    ||
    (
        Len('sbox-SCode'.Text) = 9 &&
!IsBlank(LookUp('Student Thank You Cards for Donors', SCode='sbox-SCode'.Text))
    ),
    DisplayMode.Edit, 
    DisplayMode.Disabled
)

The codes mean to turn the display mode to edit when 'sbox-Student_ID' has 7 characters and can find something in the data source using input student ID OR 'sbox-SCode' has 9 characters and can find something in the data source using input SCode.

Besides, could you please tell where is the button the codes are applied on? If it's not in a Gallery, case differs. 

Best regards,

[Jeffrey_H]

Thank you that solved that minor error.

[Jeffrey_H]

DisplayMode = 

If(
(!IsBlank('sbox-Student_ID'.Text) && !IsBlank(gal_StudentID) && Len('sbox-Student_ID'.Text) = 7 && !IsBlank(
LookUp(
'Student Thank You Cards for Donors',
('sbox-Student_ID'.Text) = Student_ID
)
)) || (!IsBlank('sbox-SCode'.Text) && !IsBlank(gal_SCode) && Len('sbox-SCode'.Text) = 9 && !IsBlank(
LookUp(
'Student Thank You Cards for Donors',
('sbox-SCode'.Text) = SCode
)
)),
DisplayMode.Edit,
DisplayMode.Disabled
)

The code above still does not seem to be working.  The button does not change to edit mode.

see screen shot here:

Search Box = filtered gallery by sbox-Student_ID = Sharepointlilst column is Student_ID

sbox-Student_ID = gal_StudentID = Student_ID

Search Box = filtered gallery by sbox-SCode = Sharepointlilst column is SCode

sbox-SCode = gal_SCode = SCode

OnSelect = Navigate('Confirm Fund/Scholarship',ScreenTransition.Cover)

Text = "Yes this is My ID Goto Next Screen"