Multiple values in Dataverse

(0) Share

Report

Posted on by lorenzobr

Hi,

I need to save multiple values in a field of a record and then count how many values are in there.

How can I do it in DataVerse?

Lookup column doesn't admit multiple values.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@lorenzobr

Have you considered multichoice field of you don't have multiple values?

The other alternative is using a new table with. 1:N relationship where you can relate multiple records to your parent record and then you can use a roll-up fields to count number of related records.

Was this reply helpful? Yes No
lorenzobr on at

Like (0)

Report

@Thanks @Mira_Ghaly for reply,
I'm using the Relate function with a N:N relationship to relate my "Partecipants" to my "Course". I need to count related records and show the number of "Partecipants" in the "Course" gallery: how can I roll-up the number of related "Partecipants"?

Thanks

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@lorenzobr

Please check the below article on how to create roll-up columns.

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/calculated-rollup-attributes#rollup-columns

Was this reply helpful? Yes No
lorenzobr on at

Like (0)

Report

Thanks @Mira_Ghaly ,
I'm trying to use your solution but I can't roll up the number of related record.
I have the table "Course" and a lookUp field "Partecipants": I created a new column as Whole Number and gave it the roll up.
In Powerapps I relate a Partecipant to Course but the count doesn't work

Was this reply helpful? Yes No
Verified answer

lorenzobr on at

Like (1)

Report

I found a solution:

in the Course gallery I created a label and on the record Text property used "CountRows(ThisItem.PartecipantLookUpTable)"

Was this reply helpful? Yes No