Announcements
Hi,
So, I have a Sharepoint list which has all the records of a form I created. Let's say I want to use a Reference ID to go back to the same record and continue answering the form questions say 3 days later using said Reference ID (Reference ID created like so in the Default pane : Concatenate(Left(User().FullName;2);"-";Text(Now(); "ddmmyy-hhmmss")) )
How would I do that ?
Do let me know if you require any further information : )
Thank you in advance,
@Anonymous
You can display the recerence ids in a gallery and then when the user selects one of them, you can open a form that uses LookUp to point to that record.
Here my list contains only IDs that have value in them.
When a I select a value, the form does a lookup in datasource for that ID.
Hope this helps.
Cheers!
Hi @narayan225 , Thank you so much for your reply.
I have tried your method and still trying to make it work.
Once I have selected my ID, what should my "OnSelect" formula look like so that I can pen a form that uses LookUp to point to that record?
i want whats in yellow to be the same record. I dont want it to create a new one. How would i do that ?Thank you in advance for your guidance
You can use a lookup formula on the form's item property to point to that record.
For example,
Lookup(tableName,ReferenceID = Gallery.Selected.ReferenceID)
Hope this makes sense.
When I keep the tab open and continue on the same screen. I do not get this error.
However, If I close the tab then reopen and try to access the form through the reference ID, I get this error.
How do I avoid these problems with data not displaying in a report ? What is the reason ?Thank you for your help,
Are you getting the data directly from the data source or are you storing the data to the collection and then getting it into the form?
This usually happens when the record you are trying to access cannot be found in the source. I suggest your run On App Start and then run your application for testing.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 395
WarrenBelz 352 Most Valuable Professional
Kalathiya 287 Super User 2026 Season 1
