cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mattw112IG
Level 8

SharePoint and Flow Form integration

ok last little thing to get this working just right.

 

I created a PowerApp with 3 forms (and a Flow) and connected to SharePoint list.  Everything is working perfectly... but one thing.

 

So if I go to "New" and fill out my PowerApp form, everything works great and once I submit it returns to the SharePoint list and displays my new record as expected.

 

But, if I then immediately click "New" again or click on any of the items in the list.  PowerApp opens and performs the SharePointIntegration "OnNew" code (even if I click on the edit link for an existing item)? But also throws an error "The requested operation is invalid.  Server response: A binary operator with incompatible types was detected.  Found operand types 'Edm.GUID' and 'Edm.String' for operator of kind 'Equal'."

 

But if I refresh the browser, then click on an item or click on "New" everything works as expected again?

 

I'm doing a reset of all my forms OnSave and OnCancel and OnNew...

 

Is this a known issue?  Is there something I'm doing wrong?

 

Thanks,

Terry

 

 

5 REPLIES 5
Community Support Team
Community Support Team

Re: SharePoint and Flow Form integration

Hi @Mattw112IG,

Could you please share a bit more about the error message within your app?

Do you custom a form for your SP list using PowerApps?

I have made a test on my side, and don't have the issue that you mentioned.

Please take a try to modify your formula within the OnNew, OnEdit, OnView property of the SharePointIntegration control as below:

OnNew:

Refresh('YourSPList');
ResetForm(SharePointForm1);
NewForm(SharePointForm1)

OnEdit:

Refresh('YourSPList');
ResetForm(SharePointForm1);
EditForm(SharePointForm1)

OnView:

Refresh('YourSPList');
ResetForm(SharePointForm1);
ViewForm(SharePointForm1)

then check if the issue is solved.

In addition, please also consider take a try to turn off/disable the "Use GUID data types insteaf of strings" option (if it has been enabled) within Advanced settings of App settings of your app, then re-publish your app and re-load it, check if the issue is solved.

If the issue still exists, please consider take a try to remove the custom form for your SP list, and re-create a new one for it, check if the issue still exists.

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mattw112IG
Level 8

Re: SharePoint and Flow Form integration

Thanks for responding!

 

Answers to your questions:

Full error is in my original post.

 

Custom Form within SP

 

When I looked at my formulas I did not have the Refresh('SP List name'); so I was thinking that was it.... so I added it everywhere and saved/published... no luck same behavior.

 

Use GUID Data is off already.

 

I really dont want to have to recreate a new one.  This one is pretty complex, multiple forms, flows, etc.

 

Really hoping this is something easy to fix or known issue.

 

Like I posted, this only happens right after something new is created and saved.

 

If I refresh the broiwser everything works again.  It seems like the browser is the one getting confused here?

 

Thanks,

Terry

Community Support Team
Community Support Team

Re: SharePoint and Flow Form integration

Hi @Mattw112IG,

Have you solved your problem?

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved already.

If the issue still exists, please consider take a try to clear cache of your browser or run your custom form using other browsers, then check if the issue is solved.

For further help in this issue, you could also consider take a try to submit an assisted support ticket through the following link:

https://powerapps.microsoft.com/en-us/support/pro/

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mattw112IG
Level 8

Re: SharePoint and Flow Form integration

Not to be short but I think you can tell from the last message it isn't solved so this must be an automated note?

Visuary
Level: Power Up

Re: SharePoint and Flow Form integration

I'm having similar issues when loading the forms after submitting an item or cancelling.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 231 members 5,291 guests
Please welcome our newest community members: