Reading data from a recently submitted form offline

Filling in a new instance of a form completely offline How do i locally query from a previously submitted instance of the same form ?

1. What is the issue? Please be detailed.
Filling in a new instance of a form completely offline How do i locally query answer to a question from a previously submitted instance of the same form ?

2. What steps can we take to reproduce this issue?
I have attached excel form and when i try to read data using collect from the previous submitted form it does not work.

3. What have you tried to fix the issue?
I tried a query as follows to read from a previous submitted form

instance(‘aXv9sWPY5YJpb4XQwdzPyM’)/root/data[contains(pname, ${search_name} )]/cnic

4. Upload any forms or screenshots you can share publicly below.
Attached form

aXv9sWPY5YJpb4XQwdzPyM - 2026-06-23T082454.056.xlsx (19.8 KB)

Welcome to the community, @jurrefws! Maybe you could achieve this with the following two approaches: