Forum Discussion
Get-PnPListItem not retrieving column data
I'm having an issue with Get-PnPListItem where I'm getting the content of a list. I'm wanting to make a change on each item in the list. For some reason even when telling the command which columns to ...
I have actually done this already. Pretty much the same procedure to determine the internal name just in case it was different.
I tested by adding the responses to an object and reviewing. Unless I did as mentioned it would always miss a few columns.
Part of the reason I'm messing with the columns is that it is a migration from 2013 and has many lookup columns. Since PowerApps doesn't support that many lookups I have to swap the lookups for textboxes and go back with PowerApps and add DDLs. I'm wondering if the restrictions on lookup columns is causing the issue. I noticed in views I was not able to add all the lookup columns either.
I tested by adding the responses to an object and reviewing. Unless I did as mentioned it would always miss a few columns.
Part of the reason I'm messing with the columns is that it is a migration from 2013 and has many lookup columns. Since PowerApps doesn't support that many lookups I have to swap the lookups for textboxes and go back with PowerApps and add DDLs. I'm wondering if the restrictions on lookup columns is causing the issue. I noticed in views I was not able to add all the lookup columns either.
ComputerHabit Sorry I could not help! If it would be me then, even I will first query the required items and make an array of ids for which I need to run some updates. Then I would just pass that array to do the intended business operation. I tried at my end but unfortunately I could not replicate but I am trying in a new site not in an migrated site. That might be the difference. Best of luck 🙂