Patch

(0) Share

Report

Posted on by toman_lukas85

Hello,

I have a problem.

I have an application in Power Apps that is used to enter revision data.

I use the following to collect and then submit the data to a sheet in Sharepoint:

but if I perform the Patch function here: {Category: ForAll(drpCategory.SelectedItems; {Value: Value})}; // Multiple values
then no data shows up in the sharepoint list.
The column is set as multiline text

Source data for drpKategorie : Distinct(KATEGORIE; Nadpis)

Target: Row > Kategorie list REVIZE_HM

Here is Patch method:

Patch(

Revize_HM;

Defaults(Revize_HM);

{Kategorie: ForAll(drpKategorie.SelectedItems; {Value: Value})};; // Multiple values

{Subkategorie: drpSubkategorie.Selected.Value};

{Stav_Detail: drpDetail.Selected.Value};

{Predmet_kontroly: drpPredmetKontroly.Selected.Value};

{Zjisteny_Stav: drpZjistenyStav.Selected.Value};

{Title: dprHM.Selected.Nadpis};

{Stav_text: ZjistenyPopisZadani.HtmlText};

{Score_sub1: Rating_Subcat.Selected.Value};

{Score_Predmet_1: Rating_detail.Selected.Value};

{Score_zjist_1: Rating_predmet.Selected.Value};

{Score_detail_1: Rating_predmet_1.Selected.Value};

{Reseni_naprav: drpReseniNapravy.Selected.Nadpis}

);;

Reset(dprHM) & Reset(drpKategorie) & Reset(drpSubkategorie) & Reset(drpDetail) & Reset(drpPredmetKontroly) & Reset(drpZjistenyStav) & Reset(drpReseniNapravy) & Reset(ZjistenyPopisZadani) & Reset(Rating_Subcat) & Reset(Rating_predmet) & Reset(Rating_predmet_1) & Reset(Rating_predmet) & Reset(Rating_detail) & Reset(drpHMselect) & Reset(DropSelectKategorie)

Please hellp :-), thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
It's a little hard to follow, but I think this is what you are going for

If Kategorie part is multiple records for one submit

Patch( Revize_HM; Defaults(Revize_HM); ForAll(drpKategorie.SelectedItems As itemsToPatch; { Kategorie: itemsToPatch.Value; Subkategorie: drpSubkategorie.Selected.Value; Stav_Detail: drpDetail.Selected.Value; Predmet_kontroly: drpPredmetKontroly.Selected.Value; Zjisteny_Stav: drpZjistenyStav.Selected.Value; Title: dprHM.Selected.Nadpis; Stav_text: ZjistenyPopisZadani.HtmlText; Score_sub1: Rating_Subcat.Selected.Value; Score_Predmet_1: Rating_detail.Selected.Value; Score_zjist_1: Rating_predmet.Selected.Value; Score_detail_1: Rating_predmet_1.Selected.Value; Reseni_naprav: drpReseniNapravy.Selected.Nadpis} );; Reset(dprHM) & Reset(drpKategorie) & Reset(drpSubkategorie) & Reset(drpDetail) & Reset(drpPredmetKontroly) & Reset(drpZjistenyStav) & Reset(drpReseniNapravy) & Reset(ZjistenyPopisZadani) & Reset(Rating_Subcat) & Reset(Rating_predmet) & Reset(Rating_predmet_1) & Reset(Rating_predmet) & Reset(Rating_detail) & Reset(drpHMselect) & Reset(DropSelectKategorie)

IF Kategorie is a choice column that contains multiple items in one record

Patch( Revize_HM; Defaults(Revize_HM); ForAll(drpKategorie.SelectedItems As itemsToPatch; { Kategorie: ForAll(drpKategorie.SelectedItems; {Value: Value}); Subkategorie: drpSubkategorie.Selected.Value; Stav_Detail: drpDetail.Selected.Value; Predmet_kontroly: drpPredmetKontroly.Selected.Value; Zjisteny_Stav: drpZjistenyStav.Selected.Value; Title: dprHM.Selected.Nadpis; Stav_text: ZjistenyPopisZadani.HtmlText; Score_sub1: Rating_Subcat.Selected.Value; Score_Predmet_1: Rating_detail.Selected.Value; Score_zjist_1: Rating_predmet.Selected.Value; Score_detail_1: Rating_predmet_1.Selected.Value; Reseni_naprav: drpReseniNapravy.Selected.Nadpis} );; Reset(dprHM) & Reset(drpKategorie) & Reset(drpSubkategorie) & Reset(drpDetail) & Reset(drpPredmetKontroly) & Reset(drpZjistenyStav) & Reset(drpReseniNapravy) & Reset(ZjistenyPopisZadani) & Reset(Rating_Subcat) & Reset(Rating_predmet) & Reset(Rating_predmet_1) & Reset(Rating_predmet) & Reset(Rating_detail) & Reset(drpHMselect) & Reset(DropSelectKategorie)

Was this reply helpful? Yes No
toman_lukas85 8 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for the reply however... now this problem has arisen : Invalid argument type(text). The value of record is expected

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
That jus tmeans one of your columsn on sharpeoint is something like a choice column. You cant patch those like columnName: "Strawberries", it has to be Provided as records. should be something liek in secodn example where we do

ForAll(drpKategorie.SelectedItems; {Value: Value})

Was this reply helpful? Yes No