JSON function with a selected gallery item to Flow

[GhassSD]

I'm trying to send a record to Flow with the JSON function based on gallery item selected.

JSON(Gallery.Selected)

but it produces an error in the formula.

Any ideas on how to get this working with a selected gallery item ?

[Pstork1]

The problem is that there are too many unsupported column types in the standard record that you get using the gallery selected. The easiest way I've found to do it is to do a ShowColumns() on the data source to select just the columns you want and then do a Lookup on that using the Gallery.Selected.ID.  Something like this.

JSON(LookUp(ShowColumns(datasource,"Title","ID"),Gallery1.Selected.ID=ID))

Just add all the columns you want to pass to the flow to the ShowColumns function.

[GhassSD]

Thanks for your reply,

This gallery point on SharePoint files, which column give the actual file content of the selected files ?

I need the content of that file in order to add in flow and send it as attachement
 

[Pstork1]

In that case you would be better off sending the File ID of the selected gallery item to the flow and have flow retrieve the file and content directly using the file id.  For that you won't have to translate anything to JSON and it will be a much smaller package beign sent to the flow which should improve performance.