Power Platform Community Forum Thread Details

I am using Big 5 model personality test openness, conscientious, extraversion, agreeableness, neuroticism so how do i generate test results below are the questions. also im using dataverse as data source

Questions

1.openness

a)High b)Low c)medium

2.conscientious

a)High b)Low c)Medium

3.extraversion

a)High b)Low c)Medium

4.agreeableness

a)High b)Low c)Medium

5.neuroticism

a)High b)Low c)medium

My query is how to get the scores using custom prompt

Categories:

AI Builder

try the following steps:

Create a Dataverse Table
Columns:
UserID (Text/Email)
Openness, Conscientiousness, Extraversion, Agreeableness, Neuroticism (Choice: High, Medium, Low)
OpennessScore, ConscientiousnessScore, ExtraversionScore, AgreeablenessScore, NeuroticismScore (Number)

Assign these values to choices: High = 3, Medium = 2, Low = 1

Build a Form: Add dropdowns for each personality trait. Submit button. Submit Logic (PowerFx):
button's OnSelect:
Patch(
PersonalityResults,
Defaults(PersonalityResults),
{
UserID: User().Email,
Openness: Dropdown_Openness.Selected.Value,
Conscientiousness: Dropdown_Conscientious.Selected.Value,
Extraversion: Dropdown_Extraversion.Selected.Value,
Agreeableness: Dropdown_Agreeableness.Selected.Value,
Neuroticism: Dropdown_Neuroticism.Selected.Value,
OpennessScore: If(Dropdown_Openness.Selected.Value = "High", 3, If(Dropdown_Openness.Selected.Value = "Medium", 2, 1)),
ConscientiousnessScore: If(Dropdown_Conscientious.Selected.Value = "High", 3, If(Dropdown_Conscientious.Selected.Value = "Medium", 2, 1)),
ExtraversionScore: If(Dropdown_Extraversion.Selected.Value = "High", 3, If(Dropdown_Extraversion.Selected.Value = "Medium", 2, 1)),
AgreeablenessScore: If(Dropdown_Agreeableness.Selected.Value = "High", 3, If(Dropdown_Agreeableness.Selected.Value = "Medium", 2, 1)),
NeuroticismScore: If(Dropdown_Neuroticism.Selected.Value = "High", 3, If(Dropdown_Neuroticism.Selected.Value = "Medium", 2, 1))
}
)

Use a gallery or labels to show scores for each trait:
LookUp(PersonalityResults, UserID = User().Email).OpennessScore

if you need more details, let me know.