In a flow use a deleted view (hidden)

%3CLINGO-SUB%20id%3D%22lingo-sub-2121482%22%20slang%3D%22en-US%22%3EIn%20a%20flow%20use%20a%20deleted%20view%20(hidden)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121482%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20flow%20that%20requires%20alot%20of%20columns%20to%20be%20updated.%20For%20this%20to%20work%20I%20need%20to%20use%20a%20view%20where%20the%20columns%20are%20shown.%20However%20I%20can%20not%20use%20all%20columns%20since%20the%20lookup%20threshhold.%3C%2FP%3E%3CP%3EMy%20idea%20was%20to%20create%20a%20view%20with%20the%20columns%20I%20need%20and%20then%20delete%20it%20since%20it%C2%B4s%20still%20saved%20in%20Sharepoint%20Online.%3C%2FP%3E%3CP%3EI%20just%20can%C2%B4t%20get%20this%20to%20work%20in%20flow%20when%20I%20enter%20a%20custom%20value.%20Anyone%20done%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2121482%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121759%22%20slang%3D%22en-US%22%3ERe%3A%20In%20a%20flow%20use%20a%20deleted%20view%20(hidden)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121759%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%C2%B4ve%20got%20the%20flow%20to%20work%20but%20I%20don%C2%B4t%20want%20the%20users%20to%20be%20confused%20by%20alot%20of%20views.%20I%20have%20used%20this%20in%20the%20past%20where%20I%20create%20an%20admin%20view%20and%20save%20the%20URL%20and%20then%20delete%20the%20view.%20it%C2%B4s%20still%20accessible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%C2%B4s%20no%20way%20to%20hide%20views%20in%20modern%20layout%20right%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121684%22%20slang%3D%22en-US%22%3ERe%3A%20In%20a%20flow%20use%20a%20deleted%20view%20(hidden)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121684%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F620806%22%20target%3D%22_blank%22%3E%4036048419%3C%2FA%3E%26nbsp%3Bif%20you%20reference%20a%20deleted%20view%20in%20your%20flow%20the%20flow%20will%20inevitably%20fail.%20You%20will%20probably%20need%20to%20create%20several%20views%20with%20different%20columns%20in%20each%20then%20have%20several%20Get%20items%20actions%20each%20one%20specifying%20one%20of%20the%20views%2C%20then%20have%20several%20different%20update%20item%20actions.%20It's%20not%20difficult%20I%20think%20but%20there%20are%20more%20steps%20in%20the%20flow%20than%20you%20probably%20expect.%20As%20always%2C%20come%20back%20with%20any%20questions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi,

 

I have a flow that requires alot of columns to be updated. For this to work I need to use a view where the columns are shown. However I can not use all columns since the lookup threshhold.

My idea was to create a view with the columns I need and then delete it since it´s still saved in Sharepoint Online.

I just can´t get this to work in flow when I enter a custom value. Anyone done this?

2 Replies

@36048419 if you reference a deleted view in your flow the flow will inevitably fail. You will probably need to create several views with different columns in each then have several Get items actions each one specifying one of the views, then have several different update item actions. It's not difficult I think but there are more steps in the flow than you probably expect. As always, come back with any questions.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Thank you for your reply.

 

I´ve got the flow to work but I don´t want the users to be confused by alot of views. I have used this in the past where I create an admin view and save the URL and then delete the view. it´s still accessible.

 

It´s no way to hide views in modern layout right?