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 / How to give file path ...
Power Automate
Unanswered

How to give file path and table dynamically in PAD

(0) ShareShare
ReportReport
Posted on by 150

I have created an Excel file with the table on OneDrive, when I'm trying to give those variables in File & Table Name it shows that Parameter '': Dynamic input schema couldn't be retrieved.

A1.PNGA2.PNG

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @kiran_g 

     

    if you are passing as variable for table name and file name, you should pass the id of corresponding fields. like each file has File ID, use that value to pass to the field instead of passing file name.

     

    Simmilarly use ID table to pass as input to the table field instead of table name value in the variable 🙂

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • kiran_g Profile Picture
    150 on at

    still not working

    A3.PNG

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @kiran_g 

     

    Show me how values looks like for both fields 

     

    I think you have not used table id for table variable in the flow 

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • kiran_g Profile Picture
    150 on at

    I have used the Table ID.

    A4.PNG

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @kiran_g 

     

    whether the braces in table id should be included ? should it be removed ?

    Nived_Nambiar_0-1699182224210.png

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • kiran_g Profile Picture
    150 on at

    i didn't gave an braces

    A5.PNG

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @kiran_g 

     

    One thing i missed here, i could not see any values added to row, could you show how and what values you adding ?

    That would be more helpful 🙂

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • kiran_g Profile Picture
    150 on at

    That is the problem, if I select the table name from the drop-down only it shows. when I'm trying to give the variable it shows up as nothing. I think if we gave the correct variable will it shows up.

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @kiran_g 

     

    Normally it should show up something like this :

    Nived_Nambiar_0-1699185925805.png

     

    Row field appears where you can input the required values in JSON format. 

     

    like below

    {"A":"1","B":"2"} If there are 2 columns A and B.

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • kiran_g Profile Picture
    150 on at

    Yes, that works on the cloud. But I'm trying it on the desktop

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 237 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 227 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 194

Last 30 days Overall leaderboard