web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get Sharepoint List ID...
Power Automate
Answered

Get Sharepoint List ID - Parse JSON

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi everyone,

 

I have 2 flows:

1. Create file in a dynamic Sharepoint site, save that file id to a Sharepoint list.

2. A flow where I want to delete that item dynamically. The Sharepoint site and folder can be different with every flow. 

 

The problem that I have now is that I need to specify the identifier when I want to delete an item. So to retrieve that I want to use the 'get file properties card'. But the problem with that is that I have to specify the library where the file is located (this is the Documents library). But I need to do it dynamically, if I just fill in the ID manually it works.. but now I need to retrieve that guid for other sharepoint sites aswell. 

 

So this works:

PA_1.png

 

This doesn't work:

So I made a HTTP call to get the documents library id:

dENNtoetert_1-1617788403914.png

 

But... now when I run it, the Id is empty in the documents library name.. it has a null value. But.... when I look at the JSON Parse I can clearly see that 'Id' contains the list id I need...  What am I doing wrong ?

 

pa_2.png

Hope someone can help me out..

Thanks!

Categories:
I have the same question (0)
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Ok found my issue.. It had something to do with the generated JSON. Because it was a large JSON field I clicked on the "Input -> Show ?unedited? input" and I copied the whole JSON from that instead of the JSON from the little window if that makes sense...

     

    pa_3.png

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @Anonymous 

     

    Check the full JSON Schema are there any similar Id name property already exists more than once. You might be mapping the other one.

     

    Thanks

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    Hi @Anonymous 

     

    Not sure why you don't get it in your Parse Json but have you just tried creating an expression?

     

    If you can see the path in the body output just create something like:

     

    outputs('Name of your HTTP request')?['body']?['Id']

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien


    P.S. take a look at my new blog here

  • MMT0905 Profile Picture
    86 on at

    Can you please share more about the outputs option.  Would you put this in a compose step after the parse? Do you have a screen shot or a specific blog on this you could share?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 607

#2
Valantis Profile Picture

Valantis 456

#3
11manish Profile Picture

11manish 352

Last 30 days Overall leaderboard