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 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 525 Most Valuable Professional

#2
Haque Profile Picture

Haque 308

#3
Kalathiya Profile Picture

Kalathiya 234 Super User 2026 Season 1

Last 30 days Overall leaderboard