You’re offline. This is a read only version of the page.
Announcements
1,042
Dear community,
I have watched several video's and read several articals about this topic 😞
Still i can not figure out what i am doing wrong. I find this really hard.
So i thought maybe do this step-by-step. I hope someone can help me.
What i would like is to import excel data XLEmployee.xlsx to the dataverse table called dbEMPDIR_employee
and import XLManager.xlsx to the dataverse table called dbEMPDIR_manager.
I have a table called dbEMPDIR_employee this table is empty which i would like to fill with the excel data which contains the following columns:
and i have another table called dbEMPDIR_manager which I allready filled it with data because it contains no lookup column.
This table contains also
What should i put in the empty fields of the flow to fill the dbEMPDIR_employee ?
Here are several video's and articals which i do not understand:
How to update Dataverse lookup column with Power A... - Power Platform Community (microsoft.com)
Dataverse - Create Item with Lookup field in Power Automate (angelogulisano.com)
Power automate Dataverse Lookup - How to write to the hard column - YouTube
Gr. P
Hi @PeKi72 ,
To sum it up, what you would like to achieve is listing all entries in the Excel Employee table, add them into Dataverse Employee table, where has a LookUp column gets managers from Dataverse Manager table.
First, list the Employees from Excel Employee table.
Second, you need to get specific manager from the Managers table, based on the manager column value from Excel table. So, the List rows action Filter query
Share
Report
All responses (
Answers (
PersonalNumber eq items('Apply_to_each')?['PersonalNumber']Explanation: the first PersonalNumber is column name in Manages Dataverse table, the second is column name in Employees Excel table.
At last, Add a row to Employees Dataverse table. How to create LookUp column value? You need to use the GUID from the previous List rows action. Basically, the expression would be:
/manager('items('Apply_to_each_2')?['GUID Column name']')For more details, you can refer to below blog:
How to update Dataverse lookup column with Power Automate (tomriha.com)
Best regards,
