Show SharePoint List Choice Value in a Form Datacard

Like (1) Share

Report

Posted on 14 Mar 2025 14:54:35 by SewNinja5

Afternoon,

I am creating an app to view employee data. The data is held in a SharePoint list (HR Database Draft) and many of the columns are the type Choice.

the First screen is where a name can be searched (fawn coloured box), this passed to a gallery table and on selecting from the gallery (green icon), it sets a global variable for the employee ID in the OnSelect -

Set(gblSearchEmployeeID, txEmloyeeIDSelected.Text)
 

The Next screen is a summary of the persons data in a Form . Single Text columns are working OK,

The Status box should be returning what is in the SP column, Choices of Active, Leaver etc.

The 'Manning List Ref' Agrees to the EmployeeID being passed through, in this case 8245. The Box at the top is a text box that reference gblSearchEmployeeID

I am unsure if i have set the formula in the correct property "Default". The Items property is showing as 'HR Database Draft'

Any guidance would be appreciated.

Many Thanks

Lynsey

Categories:

Power Apps component framework

Power Platform Build Tools

All responses (2)

Answers (0)

Michael E. Gernaey 36,009 Super User 2025 Season 1 on 14 Mar 2025 at 15:30:26

Like (0)

Report
Show SharePoint List Choice Value in a Form Datacard

Hi @SewNinja5

NOT to jump on to PStork1's answer is that is the answer. I am just making a suggestion that is unrelated, to your ask, but simply based on your explanation.

First, thank you so much, great pictures, great explanation.

You mentioned that you set a Global variable when you select an item in the Gallery. It appears that after setting that you also Navigate to the View Details screen?

If so, just as a suggestion/recommendation, instead of creating a global variable, instead pass it as a Context variable, which saves resources.

Example: Icon OnSelect

Navigate(DetailsScreen, Transition.PickOne, { SelectedRecord: GalleryName.Selected });

Now on your Details screen, once you set the DataSource, you could set the Item to SelectedRecord, versus doing a lookup using the ID of the record you selected in the gallery. Note: make sure the datasources of the Gallery and of the Form are the same.

Again, this is not related and PStork1 answered this question, just something I noticed.
Suggested answer

Pstork1 65,431 Most Valuable Professional on 14 Mar 2025 at 15:07:14

Like (1)

Report

Show SharePoint List Choice Value in a Form Datacard

Add .Value at the end of the Lookup.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog