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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
abm
Super User
Super User

Hi @Teresa24486 

 

Check the run history

 

Here is an example of a single choice option set. My column is called ajb_type.

 

image.png

 

Above by default from the dynamic content you can get only the integer value ajb_type. To get the Choice Text you need to use the expression. See below.

 

items('Apply_to_each')?['ajb_type@OData.Community.Display.V1.FormattedValue']

 

See my flow config

 

image.png

 

My Test Result

 

image.png

 

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

View solution in original post

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

24 REPLIES 24
abm
Super User
Super User

Hi @Teresa24486 

 

Are you talking about SharePoint choice column? Please confirm.

 

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
abm
Super User
Super User

Hi @Teresa24486 

 

Are you talking about SharePoint / Dataverse choice column? Please confirm.

 

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
Expiscornovus
Super User
Super User

Hi @Teresa24486,

 

There should be a field listed in the dynamic content called Department Value, that is the label of the choice item. You should be able to use that.

 

departmentvalue.png

Hi @Expiscornovus ,

I have used List rows and it doesnt give me the option to choose value from the choice column.

Hi @abm ,

Its a dataverse choice field.

Hi @Teresa24486 

 

Is that a multi-choice or single choice you after?

 

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
abm
Super User
Super User

Hi @Teresa24486 

 

Check the run history

 

Here is an example of a single choice option set. My column is called ajb_type.

 

image.png

 

Above by default from the dynamic content you can get only the integer value ajb_type. To get the Choice Text you need to use the expression. See below.

 

items('Apply_to_each')?['ajb_type@OData.Community.Display.V1.FormattedValue']

 

See my flow config

 

image.png

 

My Test Result

 

image.png

 

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

View solution in original post

Hi @Teresa24486,

 

Apologies for my assumption it was a SharePoint data source, my bad. Ignore my reply 😅

 

@abm is helping you out properly 😀👌

Hi @abm ,

I tried this out and I am receiving the data on my emails. But the records that do not have the field data, email isnt triggering. Not sure whats wrong.

Before adding the formula, emails were triggering. @abm 

Hi @Teresa24486 

 

The suggested answer is the way to get the choice text. That is nothing to do with the trigger. Also you mentioned records don't have the data. Did you checked the run history steps?

 

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,

The records have data for that column. I am getting the output on the column only if there is one record. For departments that have multiple values, the field displays empty. Pls advise.

hi @abm, I can confirm that I am getting the output for the column in the flow, but not in the email though for the other departments the column displays data. 

Hi @Teresa24486 

 

Could you post a screenshot of your flow?

 

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,

Image 1 is when there is a record that shows in the field but there is no data in the email field:

 

Teresa24486_0-1632567373662.png

 

Email data:

Teresa24486_2-1632567674407.png

 

 

 

 

Hi @Teresa24486 

 

I can see an error in that apply to each loop? Could you please explain?  



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 ,

Teresa24486_0-1632570973294.png

 

 

Hi @Teresa24486 

 

I can't see your mapping? Are you setting the choice text expression mapping here? Without seeing the flow its too difficult to answer this.

 

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 

With filtered departments(one department) the flow is getting completed without timeout error; I tried to breakdown the workflow but the email isnt triggering to all the recipients from the custom user table. when I remove the filter it is failing in Create csv(Create action failed).

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,396)