Skip to main content

Notifications

Power Automate - General Discussion
Suggested answer

Using Guid to grant access to a specific folder

Posted on 18 Nov 2024 13:44:47 by 2

Hi everyone,

I’m having trouble with a flow in Power Automate, and I hope you can help me figure it out.

Scenario:
We have workers on a building site who need access to a specific folder containing the relevant information for that site.

The process works as follows:

  1. An admin creates a new folder and uploads the required data.
  2. My flow generates a GUID for the new folder and creates a subfolder specifically for the workers' data, which also gets a GUID.
  3. This information (GUIDs, folder details, etc.) is then stored in a SharePoint List.

Issue:
In my problematic flow:

  • I use a "Get Items" action to retrieve the correct list entry containing the GUID. This part works, and I can confirm that I get the right GUID in a Compose action.
  • However, when I try to filter another "Get Items" action in the document library using this GUID, I don’t get any results.

What I’ve checked so far:

  • I verified that the filter query is structured correctly.
  • I confirmed that the column name in the document library matches the query.

Despite these checks, I’m still unable to get the desired values.

Do you have any tips or insights on what might be causing this issue?

Thanks in advance for your help!

Categories:
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 16,505 on 26 Nov 2024 at 11:42:41
    Using Guid to grant access to a specific folder
    Hi @abm
     
    Get items is used for list only - but I have tried using get items to specifically to filter documents library - it seems to be working !
     
    But as you said - recommend approach is get files (properties only)
     
     
    Thanks & Regards 
    Nived N
  • Suggested answer
    abm abm Profile Picture
    abm abm 32,227 on 26 Nov 2024 at 10:04:23
    Using Guid to grant access to a specific folder
     
    Hi
     
    You can't use Get Items for querying document libraries. Use Get files (Properties).
     
    Thanks
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 16,505 on 26 Nov 2024 at 02:38:56
    Using Guid to grant access to a specific folder
    Hi,
     
    Could you show how you have written the filter query - that would help to understand what the reason behind the issue 
     
    Thanks & Regards,
    Nived N

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.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard

Featured topics