cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Duckettj
Level: Powered On

powerapps Dropdown control not passing data to SQL Server database

i have a table of data that my dropdown is looking at and I can connect to this in my app.

 

What i am trying to to is pass the .selected value to my database but it can't as it's expecting a varchar and i have the error

 

"The property expects text values, but this rule produces incompatible Record values"

 

I feel that i have to create a text version of the value to pass back but can't work it out.

 

I'm trying to get teh valueback as part of a data card

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: powerapps Dropdown control not passing data to SQL Server database

.Selected.Result should do it 🙂 

 

You were close. 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

2 REPLIES 2
Super User
Super User

Re: powerapps Dropdown control not passing data to SQL Server database

.Selected.Result should do it 🙂 

 

You were close. 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

Duckettj
Level: Powered On

Re: powerapps Dropdown control not passing data to SQL Server database

Shane many thanks for the reply,

 

p.s. your videos have been a great learning tool - keep up the good work.

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 180 members 5,076 guests
Recent signins:
Please welcome our newest community members: