Unable to export all items from list on sharepoint online

New Contributor

Hello everyone,

 

here is my case:

 

I am tracking leave request of employee using list on sharepoint online. I need to export to excel all items created in this list. But when i click "export to excel" and save result as query.jpy, run it, it only shows 1 item, not all off items in that list. But it shows all items when i click export to csv. Please show me how to fix it? These are pics:

 

all items:

yulaw90_0-1631158535221.png

export to excel query.jpy:

yulaw90_1-1631158584742.png

 

export to csv:

yulaw90_2-1631158623707.png

 

Thank you so much.

0 Replies