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 / Create function in Pow...
Power Apps
Answered

Create function in PowerApps that shows Solution in SharePoint

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello, 

 

I recently posted a question which I thought I was able to find the solution for, however, I am still struggling to find the solution. 

 

I have made a app through SharePoint where I have a header (Personal Appearance) with three questions after. 

 

In the app I display three values in a drop down list: Expectation Not Met, Expectation Met, Expectation exceeded. I need to be able to display the text but be able to add the values 1,3,5 to the text so I can average out the scores.

 

I shared an image from my SharePoint for how a recored response should look. I aslo included images of the app that I created from SharePoint, but I need the Personal Appearance to show as A header (Ill provide an app for how it should look) instead of having a input box.  In SharePoint the header should contain the averaged out score from each response.

 

I am not sure where I should put the function because of what is already in the data field

 

If there is any additional questions please ask. thank you. 

How the form should look.PNG
how SharePoint entry should look.PNG
app from sharePoint.PNG
Categories:
I have the same question (0)
  • Verified answer
    v-monli-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    In the "How the form should look" image, it seems that you didn't include the column Personal Appearance. So please explain what did you mean by " A header "? 

     

    Did you mean that you want to replace the textinput control with a Dropdown control with options of 1,3,5? If so, first select the data card, unlock the data card.

    Capture.JPG

    Then insert a dropdown control, set its Items property to:

    ["1","3","5"]

    Set the Update property of this data card to:

    Dropdown1.Selected.Value

    Regards,

    Mona

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @Anonymous how are you progressing with this? Was the above reply helpful?

     

    @Anonymous 

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard