cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AneeqaPervaiz
Helper II
Helper II

Displaying Fields from Flow to Teams

Hi, 

So I have created a flow to send notification to Teams whenever a record is created, reviewed, or completed. I have used an HTTP action to post depending on the status of the record. 

I am having trouble with displaying lookup fields - I have two lookup fields of;

1. Developer - which looks up the user

2. Project - Which looks up the open projects. This is an option set. 


The post I get in Teams does not display anything in front of projects, and gives a string of numbers and characters in front of Developer. How can I fix this?

 

Thank you

2 ACCEPTED SOLUTIONS

Accepted Solutions
abm
Super User
Super User

Hi @AneeqaPervaiz 

 

You haven't mentioned what's your data source is? Believe its D365 record you creating. To get the user name you need to use Get Record, pass the identifier (GUID) to retrieve the user name. For optionset you need to check the run history and see if you could see anything called yourfieldname_label. If it exists then use that dynamic property to display the option set name. If not you need another List Record action step looking against StringMaps entity then set the field name, entity name and option set value to get the option set name.

 

Thanks



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

Hi @AneeqaPervaiz 

 

To retrieve the optionset label name you need to retrieve the stringmaps entity and set the relationship entity name, value and attribute name. Please follow the below link

 

https://himbap.com/blog/?p=3210

 

Thanks

 



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

7 REPLIES 7
abm
Super User
Super User

Hi @AneeqaPervaiz 

 

You haven't mentioned what's your data source is? Believe its D365 record you creating. To get the user name you need to use Get Record, pass the identifier (GUID) to retrieve the user name. For optionset you need to check the run history and see if you could see anything called yourfieldname_label. If it exists then use that dynamic property to display the option set name. If not you need another List Record action step looking against StringMaps entity then set the field name, entity name and option set value to get the option set name.

 

Thanks



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Flow.PNG

 

Hi, 

So this is what I did. Yet my result is still the same. Can you tell me what I am doing wrong. 

 
 

Hi @AneeqaPervaiz 

 

Thanks for your reply. If your result still showing the same id that means you are mapping the wrong field. Check the run time history and make sure what values are returned from the Get record step. Also check the mappings are from Get record action step.

 

Thanks



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hey,

Thanks for the help. 
So I have gotten the developer field to work. I looked up the results from the Get record and chose those dynamic fields in my HTTP post. That was First Name <space> Last Name. 

 

Now, I am stuck on the option set post. So this field, i.e: Project, it looks up the records of an entity. I tried the List Record action step but I am a little lost after that. Can you help me with that please?

Hi @AneeqaPervaiz 

 

To retrieve the optionset label name you need to retrieve the stringmaps entity and set the relationship entity name, value and attribute name. Please follow the below link

 

https://himbap.com/blog/?p=3210

 

Thanks

 



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Flow2.PNG

These are the steps that I have followed. Helped with both my cases. 

Thanks for the help. Appreciate it. 

 

Hi @AneeqaPervaiz 

 

If you use the CDS connector you can get the label name directly from the Get record or items. Glad to hear that you have solved the problem and thanks for the confirmation.

 

Thanks



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,082)