Share
Report,
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
4. Roles
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:
Expected Insert into SQL
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 |
| KM |
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:
I have the same question (0)
All responses (
Answers (
92
