Patch gallery data to the list

(0) Share

Report

Posted on by Dulat

102

Hi,

I have gallery with some data pulled from skill requirements data source: Job type, Job profile, Skill and Skill ID

Level and Level in number are not from data source.

Level is dropdown with predefined levels in words.

Level in number is text label with if function inside.

I am trying to patch this data to assessment datasource/storage.

I was able to patch all data except score value.

Is it possible to write scores, in the row with appropriate Skill_ID?

ForAll(
GallerySkills.AllItems,
Patch(
Assessment_data,
Defaults(Assessment_data),
{
Title: "Assessment",
Employee:User().FullName,
AssessmentBy:User().FullName,
AssessmentID:AssessmentID.Text,
SkillID: Skill_ID,
RowCount:Value(NewRowCount.Text)
}
)
)

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Dulat,

Does SkillID refer to the ID field of another list and you would like to update the score field of the corresponding row in that list?

ForAll( GallerySkills.AllItems, With( { wPatched: Patch( Assessment_data, Defaults(Assessment_data), { Title: "Assessment", Employee:User().FullName, AssessmentBy:User().FullName, AssessmentID:AssessmentID.Text, SkillID: Skill_ID, RowCount:Value(NewRowCount.Text) } ) }, //Adjust the list, column and value references Patch( SkillList, LookUp(SkillList, ID = wPatched.SkillID), {ScoreColumn: SCOREVALUE} ) ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Looking back on my code, since we already have the skill id reference we can simplify it further:

ForAll( GallerySkills.AllItems, Patch( Assessment_data, Defaults(Assessment_data), { Title: "Assessment", Employee:User().FullName, AssessmentBy:User().FullName, AssessmentID:AssessmentID.Text, SkillID: Skill_ID, RowCount:Value(NewRowCount.Text) } ); Patch( SkillList, LookUp(SkillList, Skill_ID = ID), {ScoreColumn: SCOREVALUE} ) )

Was this reply helpful? Yes No
Dulat 102 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM Thanks for having a look.
I have two lists.
one of them is requirement list.
Second list is assessment results.
So, I am trying to use first as a reference for skills set and requirements.
I have tried to modify second half of your code to patch assessment data, but it gives network/runtime error.

Thank you a lot!

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Dulat,

But the scores column is also in the Assessment list. You could patch the scores column during assessment creation.

ForAll( GallerySkills.AllItems, Patch( Assessment_data, Defaults(Assessment_data), { Title: "Assessment", Employee:User().FullName, AssessmentBy:User().FullName, AssessmentID:AssessmentID.Text, SkillID: Skill_ID, RowCount:Value(NewRowCount.Text) Score: SCOREVALUE } ) )

Should something be changed in the requirement list?

Was this reply helpful? Yes No
Dulat 102 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM
Thanks a lot!
I was doing mistake in SCOREVALUE.

Was this reply helpful? Yes No
Dulat 102 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM

Can I ask one more help?

I tried to made a function to update assessment, if it is already done according to code above.
It runs, however it does overwrite first skill info and duplicate last.
Also it writes value in last skill.

Probably I am doing something wrong here.
ForAll(GallerySkills.AllItems,
Patch(Assessment_data,
LookUp(Assessment_data, AssessmentID = AssessmentIDlabel.Text),
{Title: "Assessment",
Employee:User().FullName,
AssessmentBy:User().FullName,
AssessmentID:AssessmentIDlabel.Text,
SkillID: Skill_ID,
Skill:SkillDescr.Text,
RowCount:Value(NewRowCount.Text),
ScoreEmp:Value(Score_result.Text)
}
)
)

Was this reply helpful? Yes No