Unanswered

How To Patch create multiple records

(0) Share

Report

Posted on by KanwalKaurSaini

Hi Team,

I want to know how i can create multiple records into my sharepoint list using patch function on my button in power apps.

I have form with dropdown fields . Based on the selection of different fields , user will click button below. I have written below code on my patch button. It duplicates the records in the list instead of multiple different records.

Please assist.

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (0)

WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report
HI @KanwalKaurSaini ,

You need a structure like this

ForAll( Collnew As aPatch, Patch( 'Master data', Defaults('Master data'), { Title:aPatch.Title, Area:aPatch.Area, Month:aPatch.Month, Year:aPatch.Year, Country:aPatch.Country, Datemaster:aPatch.Datemaster } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
KanwalKaurSaini 43 on at

Like (0)

Report

Hi @WarrenBelz ,

It is not working .giving me error .

Was this reply helpful? Yes No
WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report

@KanwalKaurSaini ,

Free-typed (now corrected) - try capital A is As.

Was this reply helpful? Yes No
KanwalKaurSaini 43 on at

Like (0)

Report

Hi ,

It is duplicating same records n number of times instead of creating different records . Basically I want to create different records in my list with powerapps .

Was this reply helpful? Yes No
WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report
@KanwalKaurSaini ,

Assuming you have different records in colNew, this will certainly write each one as a new record in 'Master Data'

ForAll( Collnew As aPatch, Patch( 'Master data', Defaults('Master data'), { Title:aPatch.Title, Area:aPatch.Area, Month:aPatch.Month, Year:aPatch.Year, Country:aPatch.Country, Datemaster:aPatch.Datemaster } )

Have you checked the colleciton?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
KanwalKaurSaini 43 on at

Like (0)

Report

Hi ,

I checked the collection, it stores the same data multiple times. 😞

Was this reply helpful? Yes No
WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report

@KanwalKaurSaini ,

There is something else wrong here - that code will store each record of collNew as a new record in 'Master data'.

Please post the exact code you are using (in Text) and also go to View > Collections > collNew and post a screen shot of the contents.

Was this reply helpful? Yes No
KanwalKaurSaini 43 on at

Like (0)

Report

Hi ,

I first added code on app start property as "ClearCollect(collnew,'Master data').
on the Item property of form , I wrote LookUp('Master data',ID=Gallery1.Selected.ID)
then on the patchbutton I wrote this ForAll(
collnew As aPatch,
Patch(
'Master data',
Defaults('Master data'),
{
Title:aPatch.Title,
Area:aPatch.Area,
Month:aPatch.Month,
Year:aPatch.Year,
Country:aPatch.Country,
Datemaster:aPatch.Datemaster
}
)
)

I also tried with this code .It worked once but this is also not working. ForAll(
ShowColumns(Collection1,"Title","Year","Month","Area","Country","Datemaster"),
Patch('Master data',ThisRecord,{Title:Title,Year:Year,Month:Month,Area:Area,Country:Country,Datemaster:Datemaster}
)
)

Was this reply helpful? Yes No
WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report

@KanwalKaurSaini ,

I am lost as to why this is not working. The ShowColumns() in the second code would have no effect on the result and actually is not necessary (without it all columns are available for the Patch). The problem with the rest of the second code is ambiguity (which is why I used the As statement in mine).

You did not include a screenshot of collNew.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
KanwalKaurSaini 43 on at

Like (0)

Report

Hi ,

Please find the screenshot below

Was this reply helpful? Yes No