Submit All & Saving to Collection

(0) Share

Report

Posted on by LyonsBI_BRL

214

Got a question for the community here. I need to do two things to my current app. Currently each text field I'm running the following. Which is very ineffective. As it takes time to write to SQL and in some instances I may not have a good enough internet connection.

Patch('[dbo].[Scoring]',ThisItem,{'B1 T':'Bay 1 Time'.Text})

How could I change it so that for each text box, it's writing to the local collection for that particular EntryID. Saving the Data to the Collection.

Finally how would I create a Submit ALL button for only the rows that are showing? Right now I have Submit buttons for each row, which is very ineffective in terms of submitting information.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@LyonsBI_BRL You can patch all the fields like this (I've shown a few but you can add all of them9,
Patch('[dbo].[Scoring]',ThisItem,{'B1 T':'Bay 1 Time'.Text, 'B2 T':'Bay 2 Time'.Text, 'B2 T':'Bay 2 Time'.Text})
If you want to Submit all your records, you have to put it through a ForAll loop.
ForAll(yourCollection, Patch(.....))

Was this reply helpful? Yes No