Hello y'all,
I'm trying to create a flow that, upon pressing a button, puts all items from a gallery into an excel file. The flow works so far but I've encountered a problem:
I am filtering the data shown in the gallery, meaning that if their custom ID corresponds to the custom ID of an item, they show themselves. Using Shane Young's video about that matter, I've put together the following code:
Collect(colUsers,Filter(User_Table, Title = List.Selected.App_ID)); //Title -> ID of the user_Table's items
Set(varFilteredUsers,colUsers);
Set(varFormatJSON, JSON(varFilteredUsers, JSONFormat.IndentFour & JSONFormat.IncludeBinaryData));
ExportDataToExcel.Run(varFormatJSON);
However, while the file is saved at the designated location specified in the flow, the wrong data is shown in the excel table, meaning that it takes items from the datasource to which the "List" is connected, and not from the "User_Table" datasource. Any idea how I can solve this problem?
Thanks in advance
-CyrillosB

Report
All responses (
Answers (