Tech Battle Field

In Data verse power automate, we don't have direct option by passing the value to the field. We need to pass the Table with Id of the column. For Instance i have Table A and I am trying to update the Lookup column in Table  B, we need to pass the id of the Table A column. For Example we have Loans Table and referring loans table inside of the other table as a lookup column. to Update the Lookup column, we need to pass the value of the Loans as shown the image below. Similarly we can update the other columns like Owners based on the System Users as shown below.  

To check the value exists in different types we can use Expression in Power Automate. Following are different types of validations. If the type is string, array or object we can use expression below, if(empty(triggerOutputs()?['body/ DataField ']),null,triggerOutputs()?['body/ DataField ']) If the type is different type than string, array, if(empty(string(triggerOutputs()?['body/ DataField '])),null,triggerOutputs()?['body/ DataField ']) If the type is string, array or object we can use expression below, if(empty(triggerOutputs()?['body/ DataField _value']),null,concat(' DataField (',triggerOutputs()?['body/ DataField _value'],')'))