Within SharePoint we have the ability to create a list with lookup field types. But SharePoint is limited in returning the amount of lookup colulmns.
Within NAC we are unable to specify which fields can be retrieved and therefore all columns are retrieved resulting in an error.
Within Power Automate you have to ability to select a view in order to get only the columns that are needed.
I would like to see the ability to select the retrievable columns within the "SharePoint - Query a list" action.
Thank you very much for posting your feedback for our review. At this time, we will not be adding this request to the near-term backlog, as we are focused on other highly requested features. However, we reevaluate requests every quarter and will reach out if priorities change. Please keep the feedback coming as it is critical for our longer-term planning.
Yes, please and thank you!
I'd rather have to retrieve my item 2x or query a list 2x than have to keep creating text fields for people picker controls from N365 form to my list or have to give up lookup fields that aren't needed.
Please add this feature!