Search code examples
office365-appspowerapps

Powerapps temporary data storage


I have two tables as entities.

  1. Travel details
  2. Travellers

I will have the trip details in first table and "who is travelling list" as separate records in second table.

Here are my screens:

enter image description here

After I fill the travel details, I should hold the data somewhere and pass it to the next page and collect travellers. It is one to many relationship. One trip might have one or more travellers. Finally I should submit these to my two different entities.

Since I'm new to powerapps, it's quite challenging for me. Please help.


Solution

  • I would suggest to store the travel details ID (or whatever the primary key of the travel details table is) as a variable (context or global depending on how you want to do this) when the travel details are saved on the first screen, and then modifying the OnSelect property of the save button on the second screen to include the information stored in the variable when it writes to the Travellers table. I realise this is not very clear, but more information about the data structure and the current OnSelect property of both save buttons would help.