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 🙂 

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,972)