cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Teresa24486
Post Partisan
Post Partisan

Get value of a choice column than the ID

Hi,

I need to get value of a choice column than the ID. I have a choice column with department names,how do I get the names rather than the ID on my HTML column? Please advise.

24 REPLIES 24

Hi @abm ,

Thank you very much for your help on the session. The flow was recreated as per your suggestion. I had an extra apply to each which was giving wrong output. The formatting for the number was done by using the format number expression and that fixed the issue< formatnumber(item()?('column_name'),'##,###,###.##')>. Similarly fetching the name of the dropdown instead of value<

item()?['column_name@OData.Community.Display.V1.FormattedValue']>.

.

View solution in original post

Hi @Teresa24486 

 

There are quite a lot of changes I suggested. One was the format using the expression formatNumber(). There are other steps for the filter which was not quite right. 

 

Did you resolved your reported issue?

 

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 blogPower Automate Video Tutorials

Hi @abm,

I have a small issue with the email, I tried to add an external email to test this out and The emails are triggering regardless of the department to that specific user. Ideally I have attached that user only to one department, but I received 4 emails from other departments for the same user. Please advise.

Hi @Teresa24486 

 

For each department email content is different or not?

 

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 blogPower Automate Video Tutorials

hi @abm,

I got my issue resolved; it is emails are triggered department wise to the respective dept users. Thank you for all your help.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,253)