Power Platform Community Forum Thread Details

I have a process where I issue a standard excel-file to be used by many users, where they will then do manual working to this file.

When I issue a new version of this file, I want to use PAD to extract this data from all the files and copy over to this new version.

I have built a flow that gathers all relevant addresses to excel-files from a SharePoint and store into an excel sheet.

I then manually revise and edit this list to clear out any invalid data.

Then what I would like to do is to open those files one by one extract this information and copy over to the new version.

But I cant use the datarow information in the CurrentItem from the cells in a way that can be used as a filepath.

Should be a easy fix, but I just cant seem to figure it out. Anyone that could help?

Categories:

Open a file based on a list in excel