Tech Battle Field

Microsoft allows to connect with Data verse to ease use of Finance and Operations  by allowing the accessibility easily. One of the option in Canvas apps is "Enhanced delegation for Microsoft Data verse". Enhanced delegation for Microsoft Data verse is an option to allow users to us following functions without Delegation errors. in AsType CountIf CountRows Without selecting the " Enhanced delegation for Microsoft Data verse " option, PowerApps  will throw Delegation errors for Data verse while using the above functions.  We can enable to option by selecting the settings and enabling the " Enhanced delegation for Microsoft Data verse " as below.

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.