cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gks1595
Frequent Visitor

how to update a lookup field in dynamics 365 CE using flow

Hello,

 

I am new to flow/Automate. I have an excel file that contains list of users and columns about user's info. whenever excel file is updated, I want to update respective user in dynamics 365. I have been successful in updating all text fields but when I try to update a field which is type 'lookup' then it does not get updated. 

 

steps I have taken in my flow - 

1) list rows from excel table 2) get records from Dynamics 365 3) list records for match 4) update dynamics 365 records for specific fields.

 

I am struggling to update the lookup field for users 'site'. Any help or guidance on this will be great!

 

 
 
 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @gks1595 ,

 

Have your problem been solved?  If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
gks1595
Frequent Visitor

I have made some progress on this hurdle but not completely through yet. I found the GUID of site records in CE and replaced Site names with GUID on excel file site column. after doing this the flow successfully updated the lookup field. 

 

I would still appreciate if someone can help with how to dynamically match a record via its GUID and update it. I am thinking that I need to use some expression and/or also get the data from related to entity before Update action but that's all Pie in the sky so far.

Hello,

Use List records with a query to find the text field of the lookup. Than use a Data Operation Compose action to store the GUID.

Thanks
-Josh

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Here is one of my posts. I believe this will help.

https://powerusers.microsoft.com/t5/General-Power-Automate/Filter-Query-in-List-Records-not-working-...

-Josh

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





v-alzhan-msft
Community Support
Community Support

Hi @gks1595 ,

 

Have your problem been solved?  If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,733)