web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to Uplaod /Save ex...
Power Apps
Unanswered

How to Uplaod /Save excel table values in a Lookup Column of a dataverse table

(0) ShareShare
ReportReport
Posted on by 90

I  Have an Excel file with 3 columns  EmployeeDesignation ,   Minimumstayin months-Regular TrackerMinimumstayin months-Fast Tracker

 

Nida_Sayedi_0-1701272133583.png

I Have a dataverse table  Employeepromotioneligibility with 3 columns   EPEEmployeeDesignation(LookupColumn),   

MinimumStayinMonths-RegularTracker(Text ) ,  MinimumStayinMonths-FastTracker(Text)

 

shown below

Nida_Sayedi_1-1701272283703.png

 

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 

Nida_Sayedi_2-1701272718715.png

Nida_Sayedi_3-1701272741170.png

first(outputs('Get_tables')?['body/value'])?['Name']

 

Nida_Sayedi_4-1701273913145.png

 

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

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 840 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 332 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 275

Last 30 days Overall leaderboard