I am using a SharePoint list with a large number of fields as the backend for an automation. I've 2 views, one for the public users and another one for the robot (private to robot user). The robot private view has only the mandatory fields to update. But when I tried to update an item from the Desktop flow, the private view is not getting listed there. Bot uses the same account which the view is available. Is there any solution for that?
Power Automate can only access public views. To get around this, you could send an HTTP request to SharePoint and specify the columns you want to return: _api/web/lists/GetByTitle('{list_title}')/items({item_id})?$select=Column1,Column2,Column3
Was this reply helpful?YesNo
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.
3
Share
Report
All responses (
Answers (
