cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chrisal23
Frequent Visitor

Columns Not Found Using Experimental Features

Hi,

 

Recently, I removed all user access from a SharePoint library with the hopes this would restrict access to non-admins (huge mistake.) I didn't think I'd be locked as a site owner but I'm no longer able to access this library (view screenshot below.) However, this library is where my Power Automate workflows are pointing to so I had to come up with an alternative. I've built an identical library and have started updated my Power Automate workflows where it's currently pointing to the old library. 

 

1.PNG

 

Currently, I'm looking to match the library filename against names from a list using the "get file properties" and Filter Query option via Power Automate. The strange thing is that I'm not seeing any column options while using Experiential Features via Power Automate (view screenshot below) for both the new library and list.

 

2.PNG

 

I've tried testing this with random list and libraries and the same issue persists. Additionally, I've tried creating a new workflow and the issue persists. Really frustrating at this point as I've already had to build the new library.

 

My update flow runs successfully but it doesn't update any columns as it seems like the columns aren't being recognized (view screenshot below.) In the past I'd see the actual filename but it's not the case here so I know something is off.

 

3.PNG

 

Feedback would be appreciated if you've ever experienced this or have an idea on what else to try. Thanks!

7 REPLIES 7
Ankesh_49
Super User
Super User

@Chrisal23  Could you please try removing the action and adding it back again in the flow. Also, try clearing the browser history/cache once.


@Ankesh_49 thanks for your response.

 

I've re-added this step again to my flow and cleared my cache but the issue persists.

 

Could this be related to access? 

Ankesh_49
Super User
Super User

@Chrisal23  Could you please check the connection, being used is it correct? Generally, it throws an error in the beginning itself if you don't have access while adding the library/lists in actions

 

 

or trying adding custom value and see if it works

Ankesh_49_0-1661462102134.png

 

@Ankesh_49 thanks. I noticed there was an error under my connections, so I tried relogging in my 365 account.

 

It appears I logged in successfully but the issue persists. Could this be related to my access?

@Ankesh_49 I recently noticed that I'm able to run the workflow but receive a warning message (view below.)

 

0.png

When I click the hyperlink within this message I get taken to my flow. At that point, my flow is showing errors on two of my steps where they connect to a SharePoint library. However, when I authenticate myself and try to save my flow I get this error message.

 

25.PNG

 

24.PNG23.PNG

 

 

 

 

 

 

 

 

 

I feel like somehow my access to this SharePoint is causing an issue. If you have any recommendations please let me know. Thanks

 

 

Ankesh_49
Super User
Super User

@Chrisal23  That's what I pointed out in my post above, checking the connection and authenticating it again.

@Ankesh_49 that's the problem that I keep authenticating but can't save my updated workflow.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,705)