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.

Jcook
Super User III
Super User III

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





Jcook
Super User III
Super User III

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.

View solution in original post

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (53,490)