cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Error with Sharepoint connection

Hi,

I've got problem with SharePoint connection I guess. After ~15/20 min of work I need to remove and add connection to my SharePoint list because on every field which use LookUp/Patch etc. I've got error "Invalid Argument Type". The only way to remove those error is to remove and add new connection to the same SP list.

 

Any ideas what's going on?

 

Cheers

6 REPLIES 6
Highlighted
Helper II
Helper II

Re: Error with Sharepoint connection

Hi @nottheOther ,

 

Invalid Argument Type is normally surrounding a column that is being patched is the wrong type for the destination.

 

Could you please paste your SharePoint list columns and types as well as your code so I can recreate and investigate for you?

 

Regards,
Benjamin Western | Automation Specialist

NextStep Creations


Taking your PowerApps Skill the NextStep

Highlighted
Helper I
Helper I

Re: Error with Sharepoint connection

First button with setting variable with SharePoint list record ID

"Invalid argument type"

 

Set(editID; DataTable5.Selected.ID);;
Navigate(StepsScreen; ScreenTransition.Fade)

 

Next screen got TextFields ex.

 

LookUp(SharePointList;editID=ID; NameOfColumn)

 

Name of column - Multiple Lines of Text

Everything worked fine until few days ago till I saw that.

Highlighted
Helper II
Helper II

Re: Error with Sharepoint connection

Thanks @nottheOther ,

 

With this line: 

LookUp(SharePointList;editID=ID; NameOfColumn)

 

Try wrapping your ID from the other table in Value() just in case SharePoint is expecting an integer for this column... or visa versa if it is an integer but expects text

 

Wrap ID in Text()

 

Hope this helps!

 

Regards,
Benjamin Western | Automation Specialist

NextStep Creations


Taking your PowerApps Skill the NextStep

Highlighted
Helper I
Helper I

Re: Error with Sharepoint connection

LookUp(SharePointList;Text(editID)=ID; ColumnName)
LookUp(SharePointList;Value(editID)=ID; ColumnName)
LookUp(SharePointList;editID=Text(ID); ColumnName)
LookUp(SharePointList;editID=Value(ID); ColumnName)
LookUp(SharePointList;Text(editID)=Text(ID); ColumnName)
LookUp(SharePointList;Value(editID)=Value(ID); ColumnName)

None of this worked. It used to work as a charm...

Highlighted
Helper I
Helper I

Re: Error with Sharepoint connection

I can't even set this variable with action OnSelect button!

Set(editID; DataTable5.Selected.ID)

 Incompatible Type. We can't evaluate your formula because the values being compared in the formula aren't the same type.

 

Any help?

Highlighted
Helper I
Helper I

Re: Error with Sharepoint connection

Ok situation update. Everything works again.

 

What I've done?

 

Renamed name of the variable in every place. From "editID" to "editedID". Aaaand it works again XD

Amazing. I think it's a bug not a feature 😉

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (5,559)