Power Platform Community Forum Thread Details

Hi,

I have a excel file named 'EmployeePromotionEligibility' and Dataverse table named 'EmployeePromotionEligibility'. I have one Lookup (EPEEmployeeDesignation) column in Dataverse. now I want to store the data in excel into Dataverse (lookup column) when I upload the excel file from power automate.

Can anyone please help me on this.

I am attaching the Excel file and Dataverse table below.

Thanks!