cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
My_connect
Advocate II
Advocate II

power automate get option set numbers from Dataverse current environment

Hi all,

 

Could someone shed some light Please !

 

Im trying to push data from Dataverse (2021) to SQL(v2) using power automate and stuck with one field 'Range"

Choice column 'Range' has options like (500,1000,1500,2500... etc) when i tried to call it using flow im getting error because value returned is null

 

Im able to pickup other choice columns using 

 

TStatus =  @ {triggerOutputs()?['body/_toons_Tstatus_label'] - works as expected

 

Range =  @ {triggerOutputs()?['body/_toons_Range_label']}  = null 😞 

Range =  @ {triggerOutputs()?['body/toons_Range']} = also null 😞 

 

Any suggestions please , Range =  ?

 

Thanks in advance 

Connect 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
My_connect
Advocate II
Advocate II

Found the error, 

I was using Choices instead of Choice, so _schema_fieldname_label will not work for choices

My_connect_0-1619814080590.png

 

Need extra pair of eyes to find this mistake 🙂 

 

 

View solution in original post

1 REPLY 1
My_connect
Advocate II
Advocate II

Found the error, 

I was using Choices instead of Choice, so _schema_fieldname_label will not work for choices

My_connect_0-1619814080590.png

 

Need extra pair of eyes to find this mistake 🙂 

 

 

View solution in original post

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!

Users online (2,550)