Forum Discussion
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...
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
https://www.youtube.com/watch?v=fqH1U0_TanI
- 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.
JohnYour 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!
- Hmm yea, you are right. I'll need to find a better solution. Any ideas?
