Hi @Adam-it
Please review.

Issue:
The commands m365 spo listitem list with parameter --fields does not seem to work with lookup columns.

When lookup column is passed to --fields parameter, it throws below error:

Error: The query to field 'Parent' is not valid. The $select query string must specify the target fields and the $expand
 query string must contains Parent.

Also, same error occurs when m365 spo listitem get command is used with --properties parameter as lookup column

Can you please verify, if you experience the same.

Except the above issue, the PR works fine.

@nanddeepn your work is awesome 🤩. I will for sure have a look on this but on Monday as I am full with work over the weekend 😥, so please be patient 🙏.
as for the issues you described I think those are perfect for improvements in the CLI for M365 tool don't you think 🤔? I think we may open an issue referencing this script as example 😉. If you want I may add an issue or if you want to do it be my guest 😍. You may tag me in the issue if you want to engage me into the discussion 👍

Thank you @Adam-it
Have a nice weekend! Please take your time for review.

Meanwhile, I have created issue pnp/cli-microsoft365#3391 at pnp/cli-microsoft365 repo.

Awesome sample - thank you @nanddeepn this should be live shortly. 😊🎉