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

Notifications

Announcements

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

I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 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,129 Super User 2025 Season 2 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,129 Super User 2025 Season 2 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,129 Super User 2025 Season 2 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,129 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard