Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building 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 825 Super User 2025 Season 1

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:
  • Verified answer
    WiZey Profile Picture
    3,023 Super User 2025 Season 1 on at
    Re: What is the best way to create a help system using a database and a form?

    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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,653 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard