Forum Discussion
PowerApps attachments as datasource
Hello Anonymous
I think it should work like this
Excel.Workbook(Web.Contents(YOURPATHFROMPOWERAPP))
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
I went and tried using parameters with what you suggested. So far it seems like progress in the right direction.
I created a funtion that I can use in conjunction with a table containing the second portion of the URL (like in the original example) where each file is uploaded
(parPath as any) =>
let
Source = Excel.Workbook(Web.Contents("https://company.sharepoint.com" & parPath))
in
Source
I then created a new query which is supposed to call the funtion and return a table of tables containing the data of each file. Following this guide.
let
Source = Paths,
path_name = Table.ToList(Table.SelectColumns(Source, "ShortPath")),
file_path = List.Transform(path_name, each get_path(_))
in
file_path
My only problem now is I am getting an error I do not quite understand and suspect that you might be right about the blocked access.