Power Platform Community Forum Thread Details

Text Box Auto Populate Based on Previous dropdown Selection Success But Patch function Failing because update property is not accepting the Value...
17 hours ago
Hi, I have been trying to auto populate a value based on the previous Drop down selection and got succeeded, But Failing when I am trying to patch the same to Dataverse table tried different approaches not sure why I am not succeeding in this scenario !!

Challenge 1 - Update Property is not getting updated.. not sure why its not working for dropdown data card and for the Textbox

Challenge 2- Unable to Patch these 2 values data to Dataverse table.

I have a dropdow1 and Text Box, Auto Populating the value based on the dropdown value selection..

Dropdown Values..

Desk1

Desk2

Desk3

Desk4

Desk5

Text Box - Auto Populate Values

If Desk1 Selected - Auto populate ( India)

If Desk2 - US

If Desk3- Europe

If desk 4- Canada

if desk5- UK

Created 2 Tables in this solution..

My Table1 (Onboardings)- Main table where I am trying to Post the data using Patch

My Table 2 ( VFilters) Which has Text Columns..

Desk Type Group

Desk 1 India

Desk 2 US

Desk5 UK

Distinct(VFilters,'Desk Type') - Updated this formula ( Dropdown Items Property) - So My dropdown is displaying all the desks available, When I select desk 1 from this dropdown using below look up the group is getting auto populated.

LookUp(VFilters,'Desk Type'=Dropdown1.SelectedText.Value).'Group' - Updated this formula in Text Box Default Property.

Value is getting Auto Populated.. But for both these Cards Unable to set the Update Property getting the below error.

Dropdown1.Selected- Not working

Dropdown1.SelectedText - Not working

Dropdown1.Selected.Value - Not working

Dropdown1.Selected.Result - Not working ( Error : Expected OptionsetValue) am I getting this error because I am using a different table to read the dropdown from Dataverse?

Same issue with text Box as well - Unable to set the property for during the patch the textinput2. Text Is not working

Patch('Onboardings',Defaults('Onboardings'),{'First Name':OFirstnamevalue.Text,'Last Name':Olastnamevalue.Text,Dom:OValueDomain.Text,'Agent':OValueDAgent_1.Selected.Value,'Desk type' ':Dropdown1.SelectedText.Value ( this is not working) Posting empty values to dataverse

Group':TextInput1.Text ( this is not working) Posting empty values to dataverse