Forum Discussion

Brass Contributor

Jun 19, 2018

Customize List Form to Use Two Lists

Hi, I want to customise a List form to be able to update two lists. My idea is to create the two lists, Header and Lines. Then choose customise on the Header List to create the Power App style form...

SharePoint Online

Anonymous

Jun 19, 2018

Reference Shane Youngs Youtube videos. He's been doing a great job with PowerApp tutorials and this one isn't 2 lists, but it shows working with 2 data sources. Just make them both SharePoint and you should be able to figure it out from this example. He also has others related such as Cascading Drop Downs etc.
https://www.youtube.com/watch?v=fqH1U0_TanI

Brass Contributor

Jun 20, 2018

That's great, thanks Christopher!

In the end I used:
Value(Last(Header).ID)+1 to link the two lists.

But thanks for the link, the videos are great.

John

Mihir Yelamanchili
Brass Contributor
Jun 27, 2018
Your formula Value(Last(Header).ID)+1 may not work always correct.
Example: You have created a header item with id 10. For some reason you/some other person have deleted this item from header list. When you try to add the item to header and lines list through power app, your formula will return you id as 10, which was deleted. So it will fail in this scenario. Is it right!
- John Condron
  Brass Contributor
  Jun 28, 2018
  Hmm yea, you are right. I'll need to find a better solution. Any ideas?
  - Michal Golka
    Copper Contributor
    Jul 05, 2018
    Install Sintel Forms and configure related lists: https://sintel.ie/products/sintel-forms/
    It is free for up to 2 forms so you don't have to pay for it.
    
    1. Create the header list, and then the related list that will contain a lookup field pointing on the header list.
    2. Enable Sintel forms on the header list and your related list will appear among the fields.
    3. Drop it into the chosen section and save the configuration
    
    You will be able to inline add and edit items as per the screenshot attached
    
    Cheers

Resources