Unanswered

PowerApps - Update Dynamics Table column based on DropDown Column Name Value

(0) Share

Report

Posted on by Wilder1626

I would like to be able to Update a specific column value in my Dynamics 364 table based on the Column name selected in a Drop Dowm menu. Based on the value selected from the drop down, it will select proper columns to action on the Patch.

This portion: scl_tscauditrequestid = GUID(txTscAuditRequestNumber.Text) will search for the unique value.

Then, if i select a value in my Drop Down menu that equals a column name inside that table, Example: "slc_Comments:", when i will press on the button, it will put the value from txNewValue.Text into "slc_Comments" column of the row corresponding to unique value that equals

to GUID(txTscAuditRequestNumber.Text)

Patch(
 'Audit dbase',
 LookUp(
 'Audit dbase',
 scl_tscauditrequestid = GUID(txTscAuditRequestNumber.Text)
 ),
 {
 cbDbColumnSelection.Select.Value = txNewValue.Text
 
 }
 )

Above code does not work. But how can i do that?

Thanks for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report
Hi @Wilder1626 ,

You cannot use a selected text value to refer to a column name.
So, you could modify the formula like this:
If(cbDbColumnSelection.Select.Value="slc_Comments", Patch( 'Audit dbase', LookUp( 'Audit dbase', scl_tscauditrequestid = GUID(txTscAuditRequestNumber.Text) ), { slc_Comments = txNewValue.Text } ), cbDbColumnSelection.Select.Value=Another column Name, Patch( 'Audit dbase', LookUp( 'Audit dbase', scl_tscauditrequestid = GUID(txTscAuditRequestNumber.Text) ), { Another column Name = txNewValue.Text } ))

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Wilder1626 89 on at

Like (0)

Report

Thanks. This will work.

Was this reply helpful? Yes No