How to give file path and table dynamically in PAD

[kiran_g]

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.

[Nived_Nambiar]

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]

still not working

[Nived_Nambiar]

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]

I have used the Table ID.

[Nived_Nambiar]

Hi @kiran_g 

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

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]

i didn't gave an braces

[Nived_Nambiar]

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]

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]

Hi @kiran_g 

Normally it should show up something like this :

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]

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

[Agnius]

You are using %CurrentItem.id% to show the table Id, but you use %Table1% in your Add a row to a table action. Are you sure those are the same values?

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

[kiran_g]

I have taken a "Table1" as Variable in there given value was %CurrentItem.id%

[Agnius]

I don't see where that's being assigned. Can you please check if it gets assigned a value before you actually try to use the Add a row to a table action? Can you share a screenshot of the entire flow?

[kiran_g]

[alextmartin]

I was so optimistic finally finding this thread as I have the same problem, but I take it this is just not possible in Power Automate Desktop the way it is in the cloud version?

[ksoze92]

I am facing the same situation, I cannot add dynamic values to "List rows present in a Table", this is awful

[ksoze92]

Did you manage to solve this? I am facing the same situation

[kiran_g]

No, But I've downloaded the file onto my machine, made modifications, and reuploaded it to Onedrive.

[ksoze92]

Hey, I've managed to make it work (List rows present in a table with an Excel file hosted in SharePoint),

I put the File path (General/Folder1/excelfilename.xlsx) and the table name (Table1) and worked. I am using the latest PAD version. No need to fetch the drive id, file id nor table id