cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
slan2018
Level: Powered On

App submitting to Sharepoint List not working

Hello,

I have a simple app that asks about 10 questions that are then put into a Sharepoint list upon Submit. I am noticing that it is spotty whether it makes it to SP or not. The App is connected to 0365 and the SP page only. Are there any settings that anyone can recommend I look at? As far as my submit button, I am using the Patch functionality- Would anything need to be added to that expression?

 

 

Patch('SEBS Proposals',Defaults('SEBS Proposals'),Form1.Updates,Form2.Updates,Form3.Updates,'Form3.1'.Updates,Form4.Updates,Form5.Updates,Form6.Updates);Navigate(Screen7)

 
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: App submitting to Sharepoint List not working

@slan2018 

There's a way you can test to see if a PATCH was successful using the ISEMPTY + ERRORS functions.

You can put your PATCH inside the ERRORS function and tell PowerApps what to do if there's an error using an IF statement.

 

If(
    IsEmpty(
        Errors(
           'SEBS Proposals',
            Patch(
                'SEBS Proposals', Defaults('SEBS Proposals'), Form1.Updates,Form2.Updates,Form3.Updates,'Form3.1'.Updates,Form4.Updates,Form5.Updates,Form6.Updates)
       )
    ),
    Notify("Patched Successfully",NotificationType.Success);Navigate(Screen7),
    Notify("There is an error with your Patch function",NotificationType.Error)
)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

3 REPLIES 3
Super User
Super User

Re: App submitting to Sharepoint List not working

@slan2018 

There's a way you can test to see if a PATCH was successful using the ISEMPTY + ERRORS functions.

You can put your PATCH inside the ERRORS function and tell PowerApps what to do if there's an error using an IF statement.

 

If(
    IsEmpty(
        Errors(
           'SEBS Proposals',
            Patch(
                'SEBS Proposals', Defaults('SEBS Proposals'), Form1.Updates,Form2.Updates,Form3.Updates,'Form3.1'.Updates,Form4.Updates,Form5.Updates,Form6.Updates)
       )
    ),
    Notify("Patched Successfully",NotificationType.Success);Navigate(Screen7),
    Notify("There is an error with your Patch function",NotificationType.Error)
)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

slan2018
Level: Powered On

Re: App submitting to Sharepoint List not working

Hi @mdevaney I will definitely give this a try. I'm a newbie so I'm just wondering what would go here: 

'[dbo].[TableName]',

or if it should literally just read that way? When I put it in like that I got the Red X error.

Super User
Super User

Re: App submitting to Sharepoint List not working

@slan2018 

See my revision above.  I was copying from my old post and missed a change.

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,539)