Hi All,
I am trying to customize a SharePoint list form in PowerApps. The first time the powerapp form is loaded, it is throwing error. The 'Item' property of SharePointForm1 is throwing error in "First(" function.
Error: Error When trying to retrieve data from Network
I've tried removing data source and added again but couldn't resolve the issue. The list doesn't have any lookup columns and this error is not occurring in other lists within the site.
Can anyone suggest the necessary steps to be taken to resolve this issue?
Thanks,
Kunal
Ah nice, thanks for coming back and letting everyone know the solution 🙂
Hope you have a good weekend!
Cheers,
Sancho
Hi @iAm_ManCat ,
I got the fix. Actually, the number of Person or Group fields exceeds the limit so I was getting this error. When I reduced the Person or Group fields to 12, the issue is resolved.
Thanks,
Kunal
Hi @iAm_ManCat ,
This is the default formula for the SharePointForm1 >> 'Item' property. I've replaced it with the formula you suggested. Still I am getting 1 error. Please see the highlighted item below.
Thanks,
Kunal
That's not what I suggested?
Hi @iAm_ManCat ,
I've changed the default mode from 'Edit' to 'New' but still it is throwing error.
Thanks,
Kunal
Hey @basukunal001
Are you trying to show a blank item when an item isn't selected? By using first, it will show the first available (lowest ID), not a blank, and I assume you are trying to have the item display a blank item when you select New vs Edit
Could you try this instead?
If(IsBlank(SharePointIntegration.Selected.ID), Blank(), SharePointIntegration.Selected)
Cheers,
Sancho