
Announcements
I Have an Excel file with 3 columns EmployeeDesignation , Minimumstayin months-Regular Tracker , Minimumstayin months-Fast Tracker
I Have a dataverse table Employeepromotioneligibility with 3 columns EPEEmployeeDesignation(LookupColumn),
MinimumStayinMonths-RegularTracker(Text ) , MinimumStayinMonths-FastTracker(Text)
shown below
I want to upload excel table values in the above dataverse table , I am able to upload all values from excel in these two dataverse columns MinimumStayinMonths-RegularTracker(Text ) , MinimumStayinMonths-FastTracker(Text) but not the lookup column
EPEEmployeeDesignation(LookupColumn)
How do i modify the flow so that data saves in lookup column as well
here is my flow
first(outputs('Get_tables')?['body/value'])?['Name']
My flow is executing successfully but no values are getting saved only in the lookup column, values are being saved in the remaining two column
Please help me what expression do i need to write or how should i modify the flow to save value in lookup column as well??
please help