Power Platform Community Forum Thread Details

Dear Team,

i need one help when excel is downloaded at given target location with same file name and table name. so that in the flow it remove the table automatically because of static table we define.

so now define dynamic table in the flow.

if excel file having multiple sheets ( Sheets1 to Sheet8) and each sheets having one table. so how retrieve a data from sheet8.

i using expression

outputs('Get_tables')?['body/value'][0]['name']
 
I think this expression is suitable for single sheet in the excel file.
but multiple sheets in the excel which express is suitable.
 