Could use some help...
I have a gallery that is filtered via two dropdown menu's. The gallery is tied to a MS SharePoint list and the gallery does not display all list items (intentionally).
I want to export only the filtered data items as displayed in the gallery. I have several dates that may or may not have data in the associated list and depending on the filter selections, some will not display in each gallery entry. The filter works but provided here for context.
Filter('MS-Sharepoint-List',('Phase:'.Value = drpdwn_Phase.Selected.Value Or drpdwn_Phase.Selected.Value="All"),
(' Risk:'.Value = drpdwn_Risk.Selected.Value Or drpdwn_Risk.Selected.Value="All"))
I have a button that
1. establishes two variables and sets them to Blank()
2. Clears a collection used to save gallery items
3. Fills collection --> ClearCollect(colGalleryItems,gallery_Data.AllItems);
4. Declares a variable and assigns the collection minus dropped columns
5. Takes above variable, formats into JSON, minus binary an unsupported types, and assigns to a new variable
6. calls my Power Automate Flow and new variable as the argument
Flow:
This works but I'm not sure if I need all of the steps...I'm stuck at the apply to each. I have been able to add select data to a pre-defined Excel file with a blank Table...but not JSON entries such as below fail. Entries with the key and followed immediately by the value work.
"Phase": {
"Value": "Approved"
},
That said, I'd prefer to generate a file (excel or CSV) and email to the user that clicks the button as the application will be available to any user that is authorized the the SharePoint site where the list exist.
