Syncing a Dataverse Choice with a separate Dataverse table

(1) Share

Report

Posted on by AB-03121629-0

Hello!

I want to have a Combo Box menu in my Powerapp that is synced to a dataverse table of users, and the choices that are made will be added to a separate dataverse table (for example: a column in an "Event" item called "credited users" that contains the choices from that combobox). Normally, I would do this through a lookup. However, Dataverse does not have the functionality to allow for multiple lookup items. Is there any way to create a column in Dataverse that contains data on multiple choices of rows from another dataverse table? or is the best way to go about this just to make a text field in dataverse that corresponds with the choices the user made. Any help is greatly appreciated!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I'm not sure I'm getting the exact question. Dataverse does allow Choice Columns that are multiselect. So if the dropdown in the first list is using a global choice value then the actual value picked by the ComboBox is a GUID that points to a Global choice list. If you create a Multiselect Choice Column in the second list that points to the same Global choice list then the values would be an array of GUIDs instead of a single GUID. That means syncing them would require a manual Patch statement, but it should be doable. Or am I missing something?

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
AB-03121629-0 70 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 I guess the issue lies in the multiple patch statement. I'd want the global choice entry to be automatically updated based on a certain column in a separate dataverse table. For example, every time I add a user to the "Users" dataverse table (which would include their name, email, phone, etc), I am updating a separate choice item by adding a choice that is just their name. I'm not sure how to do that.

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

Dataverse does not support multi-select lookups in a single column, but it natively supports selecting multiple related records through a many-to-many

relationship.

The recommended approach is to create an N:N relationship between Events and Users and use a multi-select ComboBox to manage those relationships, rather

than storing values in a text field.

Was this reply helpful? Yes No
Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I thought you were trying to sync the selection made in one list with a choice column in another. What you describe is something a bit different. It would be possible, but would require using a flow to call an HTTP API to create the new choice in the global choice list of the other list. I haven't been able to find a good short explanation of the syntax involved, but I'll keep looking.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No