Export to Excel with filter

[Cec123]

I have created a flow and uploaded it to my canvas app. I am trying to set my syntax to only export the rows I select with radio (see picture below), my syntax is currently; 

Set(varfilelink,ExporttoExcel2.Run(JSON(Filter(ColObservation1, isSelected = true), JSONFormat.IncludeBinaryData)).filelink); Launch(varfilelink);

I know I need a filter, but it keep throwing an 'Error'. Is there another function I can use?

[AngeloG]

An Idea is mark item as "selected" when you select it on your gallery (UpdateIf), then you cant use Filter to get only "selected items"

[v-bofeng-msft · Accepted solution]

HI @Cec123 :

You could try:

1\Set the Radio's Items property to

["True"]

2\Filter the data

Filter(TheGallery.AllItems,TheRadio.Selected.Value="True")

Best Regards,

Bof