Create Choice Column from a view

(0) Share

Report

Posted on by Tango

1,151

Hi,

In the Accounts table I have added a multi choice column (Category) that allows multiple choices. These options (among others) are Supplier & Customer.

I am now working on the Products table and want to add a single choice Column for Supplier but want the options to be from the Accounts table where Category column above may include the selection "Supplier"

Is this possible? Maybe with a view?

Thanks in advance for any assistance

Todd

Categories:

Microsoft Dataverse

Tables

All responses (3)

Answers (0)

Jonathan Manrique 2,678 on at

Like (0)

Report

Re: Create Choice Column from a view

Hi @Tango

Perfectly, the views you can create filters without any problem, I show you below

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution
Tango 1,151 on at

Like (0)

Report

Re: Create Choice Column from a view

Thank you @Jmanriquerios but can the contents be based off a filter ie Category = Supplier?
So if I was to add another Account record and gave it a Category of Supplier it would then appear in the list?
Jonathan Manrique 2,678 on at

Like (1)

Report

Re: Create Choice Column from a view

Hi @Tango

This functionality is possible whenever you have created the option set as global since it is added as an element of your solution that you can reuse, then depending on the need you have in a table it can be multi-selection or not depending on the business need

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution