Hi @skwan ,
Firstly, please note that the right syntax of Patch function shoule be:
Patch(tablename,Defaults(tablename),{.....}) //create a new record
Patch(tablename,one item,{....}) //edit an existing record
Secondly,the formula that you use:
{ID: Blank()}, Form1.Updates, { Name: [@PowerBIIntegration].Data.Name
This can not represent a record. A record shoule be like this: {field1:....,field2:.....,field3:....}
I suggest you try this:
If(Form1.Mode = New,
ClearCollect(test,AddColumns(Form1.Updates,"ID", Blank(),"Name",First([@PowerBIIntegration].Data).Name))
); //create a collection with the data of Form1,ID and Name, use First(table).fieldname could result a value
Collect('Submissions',test); //user this collection to update
Navigate(Screen3)
Here's a doc about Patch, I think maybe you need to know more about it :
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch
Best regards,
