You’re offline. This is a read only version of the page.
2
Hi,
I am trying to updates values to ERP using web service through Power Automate Desktop.
For this my input values are coming from SharePoint lists (combination values from 2 lists) after filtering on specific conditions.
For getting the values I am using Power Automate Service and passing as input variable to PAD.
My issue here is I am able to pass single value as variables to PAD but not able to pass multiple rows as input to PAD. Can someone help me on this , if there is a solution on how to pass appended list as input to PAD from service
or
directly connect SharePoint Online lists after merging and filtering as input list to PAD
1.Put your multiple rows in excel
2.Upload them by Excel Power Query. [Data-GetData-From table range] or other froms
3.In the PQ interface, if no change, just close & load directly
4.Click Refresh in Data lable
5.there will be a new sheet, in that sheet you will find [Table Design], export to sharepoint
Then make step 1->4->5 in PAD (if you need to save the file, please add into it)
Share
Report
All responses (
Answers (
