You’re offline. This is a read only version of the page.
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
}
)
)
@Crounex, no the values between {}.
The code below should do the trick:
Share
Report
All responses (
Answers (
ForAll(col_Daten As Main;
Patch(Betriebsdaten;
LookUp(Betriebsdaten; ID = Main.ID);
{
AblesewertNumerisch:Main.AblesewertNumerisch;
Bemerkungen:Main.Bemerkungen;
Mitarbeiter:Main.Mitarbeiter
}
)
)Hi @Crounex,
My apologies, I was a bit confused myself. The data sources are probably translated to English, I thought you had 2 lists (Betriebsdaten and Operational data). However, I know realize that they are most likely just a translation.
As I can see by your screenshot, your collection is linked to the SP list. Could you give the following code with ID (made slight adjustments) another try?
ForAll(col_Daten As Main;
Patch(Betriebsdaten;
LookUp(Betriebsdaten; ID = Main.ID);
{
AblesewertNumerisch:Main.AblesewertNumerisch;
Bemerkungen:Main.Bemerkungen;
Mitarbeiter:Main.Mitarbeiter
}
)
)
I hope this helps!
So it's not linked? I thought that my formula ClearCollect(col_Data;OperationalData) creates the Collections from my Sharepoint List.
Thank you for your detailed description but I am at my limit in my head and don't really understand it. I apologize in advance.
Is it maybe easier if the collection is linked to the Sharepoint List or we add the Title?
Can we possibly finish the formula/syntax together?
This is what the collection looks like:
@Crounex, ok the colData list is not linked to the list in the screenshot (BetriebsDaten). In this case, working with the ID will not work because colDaten is linked to a different List.
What columns do you have available in the colDaten collection? You could extend the LookUp query to match the specific BetriebsDaten record you want. (below an example with Title)
//Here I added a condition for the Title
//You might need to change the .Title after ThisRecord to the correct colDaten column name where you save the name (Abwasserpumpstation_Zulaufpumpe 1)
ForAll(col_Daten;
Patch(Betriebsdaten;
LookUp(Betriebsdaten; AblesewertNumerisch = Blank() && Mitarbeiter = Blank() && Bemerkungen = Blank() && Title = ThisRecord.Title);
{
AblesewertNumerisch:AblesewertNumerisch;
Bemerkungen:Bemerkungen;
Mitarbeiter:Mitarbeiter
}
)
)
You can also add a condition for the date && AbleseDatumU = YourDateOnTheHomeScreen. In short, you will have to extend the LookUp conditions with additional fields available in colDaten e.g. Title and AbleseDatumU (cannot see full name of the column in your list) in order to match the correct records. Currently we are searching for whatever record is empty, regardless if the type or date match.
I hope this helps!
@LaurensMThanks again for your quick reply.
col_Daten -> Collection
Betriebsdaten -> Sharepoint List
I create col_Data -> App:OnStart -> ClearCollect(col_Daten;Betriebsdaten).
I don't really understand about ID. Used your formula once but then I get an error:
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
