cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nottheOther
Helper II
Helper II

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
Ben-Western
Helper II
Helper II

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

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.

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

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...

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?

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,219)