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 / What is the best way t...
Power Apps
Answered

What is the best way to create a help system using a database and a form?

(0) ShareShare
ReportReport
Posted on by 831 Moderator

In the past I created a help system where when a user clicked on the help icon a lightbox popped over the app and displayed the corresponding help title and text. I am rebuilding this app and moving towards creating a side panel like the image below. The Help tab uses a form tied to a Dataverse database that contains a unique identifier (created by me), the title and the content. What is the best way to hook these up? In my head what I would be doing is this. A user clicks on the help icon. The value of that icon will be used as a lookup value against the help database which will retrieve the help title and help text. How is the best way to do this?

 

Click on the help icon in the Industry datacard on the left and the help title and text is displayed in the right side form(or do I even need a form?)

futr_vision_0-1703607422147.png


My previous endeavor used this code.

 

UpdateContext({lclPopUpMessage: LookUp('Help Contents', 'Help Field' = "industry", Message) }); UpdateContext({lclPopUpTitle: LookUp('Help Contents', 'Help Field' = "industry", Title) });

Categories:
I have the same question (0)
  • Verified answer
    WiZey Profile Picture
    3,023 Moderator on at

    Hello @futr_vision ,

     

    I think you've already got most of it figured out by yourself. Each  "Lookup()" will have to be set the way you did for each and every help icon, but that's the only hard part I'd say. 

     

    Maybe cut it short with a single "LookUp()" like this to save on network resources:

     

    With({_help:LookUp('Help Contents', 'Help Field' = "industry")},
     UpdateContext({lclPopUpMessage: _help.Message }); 
     UpdateContext({lclPopUpTitle: _help.Title })
    )

     

    Also, I don't think you need the form, just two label to display the value of your variables "lclPopUpMessage" and "lclPopUpTitle".

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard