I watched this video: -https://www.youtube.com/watch?v=jmh8eeQVAIc Everything works fine except, the list I selected it shows number in the PowerApps, I want that it should show the name according to the table linked.
Hi @Anonymous ,
Could you please share a screenshot about the issue within your app?
Do you mean that the Dropdown box in your Edit form to display number value rather than Text value (name)?
I have made a test on my side, and don't have the issue that you mentioned. On your side, you should set the Items property of the Dropdown box to following:
ShowColumns('[dbo].[Customers]', "CustomerNameColumn", "IDColumn")
then within right Properties panel, set the Value property of Dropdown control to CustomerNameColumn as below:
Set the Update property of the Customer ID data card in your Edit form to following:
Please take a try with above solution, check if the issue is solved.
I have attached my screenshot of Detailed screen and Edit screen.
It doesn't show anything on detailed screen ( Like the selected thing from the edit form screen)
Hi @Anonymous ,
Please consider make sure the the Update property of the LocationId data card in your Edit form to following:
Also please make sure the Item property of the Display form set to following formula:
In addition, please also consider set the Text property of the Label within the LocationId data card in your Display form (Detail form) to following:
Note: I assume that the locationId column is a Text type column in your data source.
If the issue still exists, please consider re-create a new app based on your data source, then try above solution, check if the issue is solved.
Hey, I have attached screenshot of the detailedscreen, I want to get the names in the field instead of numbers, and the numbers should show in SQL database. (Numbers are shown in SQL database.)
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021