Microsoft Dynamics 365 | Integration, Dataverse...

How to insert exact value in insert row rather lookup ID in power automate

(2) Share

Report

Posted on by KRAYA

,
I have table 4 table
I have Project Main with followinng details
Project is lookup from PRoejct table
User is lookup from User table
Roles is look up from Roles table
1. Project Main

Project	User	Role
XYZ	KM	Data Analyst

2. Project

project

XYZ

3. User

user

4. Roles

role

Data Analyst

I am running a power autmate to enter this data in SQL server
what i have done till now in power automate is
1.List Rows
2.Execute stored procedure
3. Insert Row

However, SQL table has been inserted with something like UID instead of actual value

Insert into SQL:

Project	User	Role
12345688900	346dgw577h	dasfg13546bhyuyi

Expected Insert into SQL

Project	User	Role
XYZ	KM	Data Analyst

Categories:

Dynamics 365 general

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Inogic 743 on at

Like (1)

Report
Copy link

Link copied!
Hi,

In Dataverse:

Project, User, and Role are lookup fields

Lookup fields store IDs, not text

If we set this id’s then Power Automate sends those IDs to SQL

This is normal behaviour and usually happens.
So please follow below
You must get the name first, then insert it into SQL.
Step 1: List rows
Use List rows on Project Main
This gives you the IDs of Project, User, and Role.
Step 2: Get the actual values
For each lookup, add Get a row by ID:

From Project table → get Project Name

From User table → get User Name

From Role table → get Role Name

Step 3: Insert into SQL
In Insert Row, use:

Use Project name

Use User name

Use Role name

Please make sure to use text value and not the lookup ID

Hope this helps.

Thanks!

Inogic

1 people found this reply helpful.

Was this reply helpful? Yes No
CU16071138-0 on at

Like (0)

Report
Copy link

Link copied!

Thanks for sharing this solution the explanation around handling lookup values instead of IDs in Power Automate is really helpful and easy to follow. This kind of clear guidance, where you can check details easily, saves a lot of time for others facing the same issue.

Was this reply helpful? Yes No