Unanswered

Patch Function for a Gallery

(0) Share

Report

Posted on by Danny_Dicaprio

Hi I have a form in my PowerApps screen and a Gallery!

on the onselect of my Add button I have added following and my gallery items is My collection

Collect( MyCollection, { Skill: DataCardValue39.Text, // Assuming DataCardValue39 is a text input control ProficiencyLevel: DataCardValue36.Selected.Value, ExperienceLevel: DataCardValue38.Selected.Value } );

Gallery Lable controls are Label6_3 :Text Property ThisItem.Skill same for the following

what Iam really looking is I want record these collection as new record in my Data Source , ( Each skill should be a new record )

but Iam unable to do it , tried using the following patch function which is not working properly

Could Anyone please help me to fix it

ForAll(

    MyCollection,

    Patch(

        'New tables',

        Defaults('New tables'),

        {

            'Emp ID': DataCardValue20_1.Text,

            'Employee Name': DataCardValue25_1.Text,

            'Official Email ID ': DataCardValue27_1.Text,

            Skills: Label6_3.Text,

            'Proficency Level': Label6_4.Text,

            'Expereince ': Label6_5.Text

        }

    )

);

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

scalca on at

Like
a
(0)

Report
Copy link

Link copied!

try using As function in ForAll
ForAll(MyCollection As ColRecord ....
and then when you're patching do
Skills: ColRecord.Skill
Proficiency Level: ColRecord.ProficiencyLevel

looping through the collection and using values of it
in your code you are referencing controls instead of collection values
hope this helps

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like
a
(0)

Report
Copy link

Link copied!

so are u suggesting me to change the formula into following ?

ForAll(
MyCollection As ColRecord,
Patch(
'New tables',
Defaults('New tables'),
{
'Emp ID': DataCardValue1.Text,
'Employee Name': DataCardValue6.Text,
'Official Email ID ':DataCardValue7.Text
Skills: ColRecord.Skill,
'Proficiency Level': ColRecord.ProficiencyLevel,
'Expereince ':ColRecord.ExperienceLevel
}
)
);
Clear(MyCollection);

this formula is also showing some error and could u help me with it ?

Was this reply helpful? Yes No
scalca on at

Like
a
(0)

Report
Copy link

Link copied!

what kind of errors ?
what about the other 3 fields Emp ID, Employee Name, Email Id ?
can you specify a little bit more what your goal is ?

Was this reply helpful? Yes No