Power Automate - Get Value of Dataverse Choice Column
Вставка
- Опубліковано 13 жов 2024
- This video shows how to get the selected label from a choice column in Dataverse using Power Automate flow.
Expression Used:
triggerOutputs()?['body/_new_choicecolumn_label']
Hey welcome to WeTechCareOfYou!
If you are a returning subscriber we wish to say thankyou!
If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: wetechcareofyo...
We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts:
✅Express VPN - Get a 30-Day Money Back Guarantee with our link.
A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider:
👉 click.linksyne...
✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage:
👉 click.linksyne...
✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint:
👉 click.linksyne...
*Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well.
Kind Regards,
The WeTechCareOfYou Team 💙
Man, I spent *days* trying to figure out how to do this. THANK YOU.
Hey Mark, thanks for the great comment and I also had a lot of issues the first time i did this. Happy the video helped :D
Simple and straight to the point. Simple Splendid teaching
Hey Emmanuel! Thankyou for the great comment and happy it helped :D
So useful! Thanks, it was hiding in plain sight!
Hey Pazzaar, thankyou for the great comment and happy it helped!
Thank you so much, this really helped me a lot
Hey Jennifer, no problem i had trouble with this one when first working with dataverse :) happy it helped!
Short and to the point like it. The choices string is taken from the same table. Do you know how to fetch the string if the choices is a lookup column from other table?
Hey yahya, you will need to get the guid of the value in the lookup column, then you can do a lookup in the linked table using the captured Guid. When you do the 2nd lookup you will need to use the Guid() function:
ua-cam.com/video/qg7HzgsTzXA/v-deo.html
I love you! Thank you for this!
Hey Karyn! Thankyou for the great comment and happy our video was able to help :D
What if this is a choice column where multiple selections are allowed?
hey thankyou for your comment. The values are still added the same way but it has the multiple selected values, so the raw data in the trigger will show like this:
testchoicemultiple": "123200000,123200001,123200004",
It returns a blank value. has there been an update to this feature or something?
hey rorsara, i just ran the flow again and it worked as it should. Please test multiple times and make sure the row saves in dataverse
Super helpful, thank you
Hey thankyou for the great comment utilisemedia! Happy it helped :D