Answered

Adding Dataverse connection has broken the App already working on SharePoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Community, @Amik ,

I had built an app to collect form entries and post them to SharePoint. It all worked until the need arose to leverage the functionality by collecting data imported to the Dataverse.

The data is collected on 2 screens: (1) labelled SharePoint_Screen, (2) labelled Dataverse_Screen.

(1) SharePoint_Screen

(2) Dataverse_Screen

The Dataverse Table has 3076 rows of data, so there is potential for delegation issues. With that said, with the current setup, when I make selections and click "Submit Review" (Screen 2), the app says "success" on a green banner. What's happening on the SharePoint list however, tells a different story...

Is there anything I should be doing next to make this work?

Sincerely.

Categories:

Microsoft Dataverse with Power Apps

All responses (3)

Answers (1)

Sort by

v-wenjuan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Thanks for your detailed description.
There are newly created items showing up in SPO but no values. Do you mean the weird symptom happens to SharePoint after you deploy the screen 2?

We would better check functions you used to create items to SPO. Please share screenshots of how you set your forms and functions for further check if possible.

Best regards,
Community Support Team _ Wenjuan Zou
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-wenjuan-msft ,

Thankyou for replying. Yes, you have correctly understood the essence of the problem. Here is the data I think you have requested.
User starts the App on Screen 1 by clicking the button. The code behind the button shown first:

The code behind the first control( and typically the others on the first screen) is below in the next screenshot

The user navigates to the second screen...
The items formula on the second screen (and typically the other controls that pull up the selections from the Dataverse table):

After the user makes the selections, then clicks Submit Review button (code shown below)
Let me know if need anything else.
Thanks
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-wenjuan-msft

I have spotted the error that is stopping the app posting the data from the app to SP. I missed off the one form in the Patch code behind the Submit Review button. So now it should have been:
Patch('Course Review Quality',varFormData,Form1.Updates,Form1_1.Updates); If(IsEmpty(Errors('Course Review Quality')), Notify("Success", NotificationType.Success); Navigate(Form1),Navigate(Form1_1), Notify(First(Errors('Course Review Quality')).Message,NotificationType.Error))

Now with the Patch code modified to hold both forms, data posts from the SharePoint Screen to SP, but not from the Dataverse screen.
Please can you advise what I need to do to get the Dataverse data through to SP?