SharePoint integration working for some but not for others?!

[lukejvarty]

Hi,

I have an application which generates an email with some extensive information and then has a second screen which allows for the user to attach files required. The attachment element is created off the back of a SharePoint list so when the user hits 'Send', it will submit form first so it should create an item in the SharePoint list with their email address as the title and all attachments they selected within the attachment element. 

This was originally working for all but recently we have noticed when several users press the 'Send' button, it does not submit the form to SharePoint but it's still working for some. As no attachments are being inserted onto SharePoint, the flow is unable to send the relevant email it is required to. 

I have tried resetting the users permissions for that particular SharePoint list but that did not resolve anything.

I hope someone can help as this is becoming a very frustrating issue 😞

Kind Regards,

Luke

[Mr-Dang-MSFT]

Hi @lukejvarty ,

Are you able to post the formula you are using? Can you copy paste the error that appears in instances when the send fails?

[lukejvarty]

Hi @Mr-Dang-MSFT ,

I use the formula 'SubmitForm(##NAME_OF_FORM##)'. When the page is loaded that the form is on, it is always reset to be in mode 'New'. 

The user who experiences these issues tried using IE and it worked for a couple of times then the same error occurred which maybe suggests it's something to do with a particular user/browser/cookies or something like that?

The error the user experiences is 'the request was not sent or there was no response from the server powerapps'.

[Mr-Dang-MSFT]

---

@lukejvarty wrote:

The attachment element is created off the back of a SharePoint list so when the user hits 'Send', it will submit form first so it should create an item in the SharePoint list with their email address as the title and all attachments they selected within the attachment element. 

---

Can you clarify this part?

If I am understanding the process so far:

1. An email is drafted on one screen of the app.
2. User fills out a form containing an attachment control to attach files.
3. The app uses SubmitForm() to create an item in the SharePoint list containing their email address and attachments.
4. A flow sends the email.

Some questions:

• What is the Item property of the form?
• Are you using NewForm() and/or ResetForm() to change the form to New mode?
• Is the attachment control inside the form control or outside of it?
• What kicks off the flow? Is it triggered by clicking a button in Power Apps? Or is the flow triggered by detecting updates to a SharePoint list?

[lukejvarty]

Hi,

Points 1, 2, 3 and 4 are all correct.

Questions:
1 - The item property of the form is empty.

2 - I have the form 'DefaultMode' is set to FormMode.New and the 'OnSuccess' is set to Attachments.Mode = FormMode.New;

3 - The attachment control is within the form.

4 - It is triggered via a button in PowerApps.

Please let me know if you have any other questions.

Thank you in advance for your help.

[Mr-Dang-MSFT]

---

@lukejvarty wrote:

2 - I have the form 'DefaultMode' is set to FormMode.New and the 'OnSuccess' is set to Attachments.Mode = FormMode.New;

---

Can you paste what you have in the OnSuccess property? I'm unclear what you meant here.

---

@lukejvarty wrote:

4 - It is triggered via a button in PowerApps.

---

Can you explain the sequence here? Earlier you said the button that submits the form does SubmitForm(). What is the entire formula and sequence of actions? Is it something like this?:

SubmitForm(form_name);
Flow_name.Run(parameters_for_flow)

[lukejvarty]

Hi, 

Please see attached image of properties of the form. Here you can see what I have set in the OnSuccess etc. 

Ah apologies, on the click of a button, the formula is 

SubmitForm(NAME_OF_FORM);
NAME_OF_FLOW.RUN(PARAMETERS);

The SubmitForm will create an item in the SharePoint list containing their email address and attachments. 
The flow then gets items on that SharePoint list where the title eq the user's email address. It will then get the content of each attachment and add to an array for use in sending the email later on in the flow.

I hope this makes sense.