Unanswered

Confirmation data was saved in SP list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I am looking for a way to display a 'Successfully submitted' message that appears only if the data has indeed been saved to the SP list. Is there a way for PowerApps to receive a confirmation from the SharePoint list that the data was saved, and to issue a warning if it hasn't?

We want users to respond to all fields, but as shown in this post the functionality making PowerApps fields 'required/mandatory' does not enforce this properly. If we make all SharePoint list items mandatory, and the user misses to fill out a field in PowerApps, their submission (list entry) will simply not save in SharePoint.

Therefore we are trying to find a way to advise the user if their submission worked or not. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi DanielaH,

May you consider to use OnSuccess property of EditForm control.
https://powerapps.microsoft.com/en-us/tutorials/control-form-detail/

Before using the OnSuccess property, please set all the columns in the SharePoint list as “Required”(according to your needs).

Then create an app based on the list. On the EditForm, set the EditForm’s OnSuccess property as: UpdateContext({message:"successfully"}), OnFailure property as: UpdateContext({message:"wrong"}).

Then add a Label control, set its Text property as message.

When the data you filled on the Form are submitted successfully, an message “successfully” will be shown on the label, otherwise, if you missed some fields, the message “wrong” will be shown on the label.

Please have a try with it. Hope it could be a reference for you.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

How can I display the kind of error and/or the specific missing required fields in the UpdateContext({message: }) ?

Was this reply helpful? Yes No
johnom 68 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Mabel
Could you advise how this confirmation can be achieved when submitting a collection to sharepoint list
regards
John

Was this reply helpful? Yes No
BungleBrain 45 on at

Like
a
(0)

Report
Copy link

Link copied!
@johnom , did you ever find a way to verify that Collect has worked on a SharePoint list?
I'm using:

Collect(mySharePointList,myCollection)

Which is working fine to add a load of entries directly into my SharePoint list, but I worry that I can't really tell, unless perhaps I try to read the data from the list afterwards and verify that it exists.

Was this reply helpful? Yes No