Announcements
I have a form that is connected to a certain table and a certain field is in the form and that field has a texbox which I removed and put in a dropdown which is connected to the same table and same field but when I want to save using a patch function (Which I need to use) it says "The type of argument 'clientName' does not match the expected type 'text'. Found type 'record'" its an SQL database I'm connected to
Hi,
If table sits in Dataverse, you can't change Data Type of a column after its saving. The only way I know for now, create a new column with a needed Data Type and delete previous.
Regards,
Alexandra
Is it a Dropdown or a combobox?
------------If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Please Subscribe to my Youtube Channel
Its a dropdown
@donnacha
Most likely, this is because you're not referencing the correct field name in your call to patch. The snippet of formula in your call to Patch should look something like this:
{clientName:Dropdown1.Selected.Fieldname
When you type a dot after 'Selected', the Intellisense should show the valid field names.
It worked! thanks!
So my ClientName: ClientNameDropdown.Selected.ClientName is fine however the rest of them are giving me errors Market: MarketDropdown.Selected.MarketName,Languages: LanguagesDropdown.Selected.LanguageName,Brands: BrandsDropdown.Selected.BrandName,Awareness: AwarenessRadio
The errors that are coming up are saying "The specified columns "Market, Languages, Brands, and Awareness do not exist" I know they don't exist in that form because the form is connected to Client which got my the "clientName" so do only have the "clientName" field in the first patch and in the second one I have the rest?
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
