Collection in Sharepoint List import

Like (0) Share

Report

Posted on 2 Jan 2023 10:33:03 by Crounex

Hello I have already received help but after consultation with my boss, I still have to change something. Currently the collection is transferred to sharepoint list but only randomly in free rows. I need to change that. How do I get it to transfer the data that is collected in my app to the correct row?
This is my App:

And this is my Sharepoint List. I Create every Day the Entrys for each Gebäude:

And this is my fromel/syntax that I built with the help of the forum:
ForAll(col_Daten;
Patch(Betriebsdaten;
LookUp(Betriebsdaten; AblesewertNumerisch = Blank() && Mitarbeiter = Blank() && Bemerkungen = Blank());
{
AblesewertNumerisch:AblesewertNumerisch;
Bemerkungen:Bemerkungen;
Mitarbeiter:Mitarbeiter
}
)
)

Categories:

General Questions

All responses (11)

Answers (1)

Verified answer

LaurensM 12,510 Moderator on 02 Jan 2023 at 12:42:09

Like (1)

Report
Re: Collection in Sharepoint List import

@Crounex, no the values between {}.
The code below should do the trick:

ForAll(col_Daten As Main; Patch(Betriebsdaten; LookUp(Betriebsdaten; ID = Main.ID); { AblesewertNumerisch:Main.AblesewertNumerisch; Bemerkungen:Main.Bemerkungen; Mitarbeiter:Main.Mitarbeiter } ) )