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 :
Power Platform Community / Forums / Power Apps / If Lookup SharePoint
Power Apps
Answered

If Lookup SharePoint

(1) ShareShare
ReportReport
Posted on by 438

Hello, I'm trying to figure out how to display an asterisk (*) on the gallery if the prerequisites for a course are marked as "Yes" then with ThisItem.'Title Course'

 

If match say yes, then will shows as "*AMERICAN SIGN LANGUAGE 1".

Screenshot 2023-11-03 224200.png
Screenshot 2023-11-03 223838.png
Categories:
I have the same question (0)
  • ANB Profile Picture
    7,250 Super User 2026 Season 1 on at

    Hi @dylandavis09 , If I understood your requirement that you want to display an asterisk (*)  in front of Title Course, then try below on Text property if the prerequisites of Yes/No type.

    If(ThisItem.Prerequisites = true, "* " & ThisItem.'Title Course', ThisItem.'Title Course')

    if the prerequisites of Single line text , then use below:

    If(ThisItem.Prerequisites = "Yes", "* " & ThisItem.'Title Course', ThisItem.'Title Course')

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

    Thanks,
    ANB


  • dylandavis09 Profile Picture
    438 on at

    @ANB , I did add it and still not working. FYI, SharePoint column is value Yes or No. Maybe, you forget to add the SharePoint data?

    Screenshot 2023-11-04 011920.png
    Screenshot 2023-11-04 011636.png
  • ANB Profile Picture
    7,250 Super User 2026 Season 1 on at

    Have you tried this:

    If(ThisItem.Prerequisites = true, "* " & ThisItem.'Title Course', ThisItem.'Title Course')

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

    Thanks,
    ANB


  • dylandavis09 Profile Picture
    438 on at

    Yes, the same thing I tried this. Possibly, you forget to add the ShaerPoint data?

  • ANB Profile Picture
    7,250 Super User 2026 Season 1 on at

    Can you show me the Items property of gallery? What all column you have for the item property of gallery.? Show the Output of the item property.

     

    Thanks,

    ANB

     

     

  • dylandavis09 Profile Picture
    438 on at

    Screenshot 2023-11-04 015023.pngScreenshot 2023-11-04 014941.pngScreenshot 2023-11-04 014909.png

  • ANB Profile Picture
    7,250 Super User 2026 Season 1 on at

    Hi @dylandavis09 , If you can help with this screenshot:

    ANB_0-1699077915818.png

    This code is working for me:

    If(ThisItem.Prerequisites = true, "* " & ThisItem.'Title Course', ThisItem.'Title Course')

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

    Thanks,
    ANB


  • dylandavis09 Profile Picture
    438 on at

    Here y'all 🙂

     

    Screenshot 2023-11-04 021155.png

  • ANB Profile Picture
    7,250 Super User 2026 Season 1 on at

    Hi @dylandavis09 , I can see that Prerequisites is returning the record which mean that it is not Yes/No column type in SP. Can you share the screenshot of SP list column. Go to List Setting from SP list and get this screenshot:

    ANB_0-1699078633416.png

    I have one list and I am using Checked column with Yes/No type.

    ANB_1-1699078754361.png

    I am sure that the Prerequisites is not Yes/No type column. Please change and try again.

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

    Thanks,
    ANB


  • dylandavis09 Profile Picture
    438 on at

    Here. 🙂

     

    Screenshot 2023-11-04 022347.png

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 372 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 303 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 238 Super User 2026 Season 1

Last 30 days Overall leaderboard