Announcements
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
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:
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!
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 😉
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 409 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 252 Most Valuable Professional
