Forum Discussion

Hnin_Yu's avatar
Hnin_Yu
Copper Contributor
Dec 24, 2020

Patch in save function of SharePoint Integration

Hello,

 

I am facing some issues in power app in save function. I used customize form with power app in SharePoint online.
In save function , I need to use Patch() instead of submitform(SharePointform1). Sometimes it is saved data and sometimes it is not. How can I do it? Please help me! What's wrong in it?
I used the following code.
 If(SharePointForm1.Mode=New,
(Patch('Details',Defaults('Details'),{'IGT Site Code':{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value: DataCardValue163.Selected.Title},'Project Number':DataCardValue1.Text})), Patch(' Details',First(Filter('Details','Project Number'=DataCardValue1.Text)),{'IGT Site Code':{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value: DataCardValue163.Selected.Title},'Project Number':DataCardValue1.Text}));
Pow
PowerApps
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Dec 27, 2020

    Hnin_Yu why do you need to use on the customised form instead of SubmitForm(SharePointForm1) ?

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

Resources