I have 2 sharepoint lists - we will call them Customer Info and Meeting Info.
Couple of columns from Customer Info are combined to create a new column in Customer Info list - called SpecialID. This SpecialID column is used as a look up on the Meeting Info List.
Created a power app and on 1 page (CustomerPage) - connected to Customer Info list - the users click on data card - and it takes them to another page(Meeting Page) (NewForm) which is connected to Meeting Info list. The users need to fill out information and click on Submit Form and these additional information will now need to be saved in Meeting Info list. In effect for 1 record in Customer Info - multiple records need to be created in Meeting Info list.
Current situation - CustomerPage shows all information as required, users are able to click on Loginfo ( a button) - and it opens the MeetingPage and it defaults to the customer data ( did this using the Default for drop down fields & Odatatype). Once we fill out remaining information and click submit - while the records is created in the list - not all columns are filled out.
The defaulted column is not being filled out and so are couple of date columns. What am I missing? Should I use patch command and if so - how would i use it for few columns and not others?
Could you please share more details about the App you created, specially after navigate to the New form screen (which connects to the Meeting info)?
If Meeting info List has multi to one relationship with the Csutomer info list, and you would like to update all the meeting items for the same customer selected in Gallery in the Meeting info list, then you would need to take use of the Patch () and the forall () function.
Its more like new data entry for an existing parent.
The customer list is static/only few folks can update it. Each customer is shown as a data card with information about them. The users of the app will click on a button on each data card and from there be re-directed to a newform where the customer information is auto filled out and they are expected to fill out some other relevant information. On submit all of this data needs to get stored in new list.
So every time a new meeting is held the organizer will click on customer and fill out updates. So the Meetinginfo list will have many entries for one customer.