Power Platform Community Forum Thread Details

@rampprakash Thanks for your Answer but it is not working.

Let me try to explain in detail:

I have one Table in Dataverse (Manhours) with following columns:

Now I used one FORM for this table. When I press one submit button after filling details in this form I am creating one collection (displayed in Gallery5) too where I am storing all FORM submit entries. Please note this Submit button actually not for SUBMITFORM function.

Gallery5:

Now I want to Patch this Gallery back to my Dataverse Table using this ForAll and Patch functions.

I used Following Formula:

ForAll(Gallery5.AllItems, Patch(Manhours, Defaults(Manhours), {WOrder:glry5WO.Text, 'Lab Supervisor':LookUp(Manhours, 'Lab Supervisor'.Supervisor = glry5Sup.Text), 'Service Engineer': LookUp(Manhours, 'Service Engineer'.'Engineer Name' = glry5eng.Text), 'Date Started':glry5DS, 'Date Completed': glry5DE, 'Actual Work Hours': glry5AH.Text, Remarks: glry5Remarks.Text}))

But this formula is showing following error:

What formula shall I use?

I hope now its clear.

Categories:

Building Power Apps

From the error message you are trying to create a record that is not matching the table you are patching to. It appears some of the data is not the correct type (ie: you are supplying a text value and it wants a number) and/or the names are not correct or you are not providing a value to a field that is required. You have the Engineer Name being patched with a text value, but it is a Lookup, so I believe it needs a record. I'm not sure what glry5DS is but is it a valid date/time? It will be tedious, but you just need to make sure everything matches. The error messages usually let yo know what PowerApps expects, you just need to go column by column. It is also complaining that some values don't exist.