SharePoint Lists and Libraries Relationships using Power Apps

This video will teach you how to create lists and library relationships in SharePoint using the Lookup column.
You will learn how to create a functional interactive app to display parent list items and all related child list items and documents from the corresponding document library on a single screen.
Reference video: Upload document to SharePoint document library using Power App. • Power Apps for SharePo...
Connect with me
Twitter: @deepak_s22
Website: www.deepakshri...
Facebook Page: / deepak-shrivastava-108...
#PowerAutomate #SharePoint #List #Library #Relationship

[@shaiksamad1562]

Deepak.. I love watching your demoes. One great thing about your demoes are you will make things very simple and your explanation is crystal clear.. Please keep it up and we are thankful for your efforts.

[@DeepakShrivastava]

Thanks a ton

[@kansari36]

Amazingly simple. Many thanks to show nice technique.

[@DeepakShrivastava]

Thanks for watching!

[@designmycity]

You did an amazing job. Thank you very much for this great video.

[@DeepakShrivastava]

Glad you enjoyed it!

[@adityadeshmukh3150]

Thanks for sharing this idea.. Very useful..!! 😊👍

[@DeepakShrivastava]

Thanks for liking

[@EllieCarter5225]

Great video. I love it as you get to the point. Recently I've watched videos that get off track and the video ends up being over 1-2 hrs and I walk away confused. I Appreciate you sharing, thank you so much.

[@DeepakShrivastava]

Thanks 🙏🏻

[@myoheinhtet5468]

You saved my day😭

[@uiterlex]

Thank you, Deepak, practical solution and explained well. Gr. Lex

[@DeepakShrivastava]

Thanks a lot.

[@TheRemyRomano]

Very nice. Seems easy enough.

[@DeepakShrivastava]

Thanks for watching!

[@fam.giannakisflores7780]

Hi Deepak, excelent video, a quick question, why dont you use document sets as you did in a previous video, it is possible to do somethig like that?

[@wendymeyer1250]

Very helpful video. Thank you.

[@DeepakShrivastava]

You're welcome!

[@ryanbond8022]

Hi Deepak, I don't normally use the lookup in SP when I have parent-child tables, and just associate the two in PAs. So I'm looking forward to trying using your method. Would you consider doing a video soon on exporting data for reporting purposes when it comes from multiple tables which has been created by PAs?

[@DeepakShrivastava]

Thanks Ryan, yes i will add that to my list :) thanks for suggestion.

[@ajaychoudhary5596]

Awesome Deepak 👌👌👌🙏🙏🙏

[@DeepakShrivastava]

Thank You 🙏🏻

[@bernarat]

Hi Deepak! Thanks for the video. I would like to know how you connected the documents for this app? Which video should I look for? Thanks!

[@mortenlie3898]

Hello. regarding Lookup. I have several sharepoint lists that do not need lookups. do you have to use lookups to make this app? I believe that lookup should only be used if you need to be able to create a task directly from power apps.

[@geojaya]

Thanks Deepak - something that I have looking forward. Question - when you add a new task list for a project on the app, does it save it back to sharepoint task list?

[@DeepakShrivastava]

Thanks for watching. Yes it add back to SharePoint list.

[@kansari36]

@@DeepakShrivastava IT seems that its not adding. Please share if you have solution. I got stuck

[@jovannijabat2004]

Thanks Deepak. Great tutorial. May i know how could i also pass other data from the first Gallery when adding a new task, not only the project reference but also the Department Column Data. Thanks again.

[@hollylandrum5213]

Thank you so much for this. I'm having one issue I can't seem to fix. When submitting within Task Detail form, the Project Reference name does not get saved into the column. Since that value is left as blank, it is not showing as related on my Details Screen.

[@DeepakShrivastava]

Thanks for watching. In the video at 16:00, I explained how to set the project source default value. Check if you did that. Note that I am using Project source as a lookup column in SharePoint

[@hollylandrum5213]

@@DeepakShrivastava Thanks so much for your help. I've got everything figured out and my app all built

[@hamyu112693]

Hi thanks for the video, very useful. I have a question thought, when I am trying to enter the Filter formula in creating the DetailScreen, it showed a yellow warning saying Delegation warning. I have change the limit to 2000 and still exist this warning. however, my 2 microsoft lists have only 32 rows and 7 rows respectively. Is there any solution? Thank you very much

[@AkhilDev007]

Hi Bro, excellent video. I have an SP list out of which one is a choice column. How to view that in PowerApps gallery. This item. 'xxxx'.Value is giving me an error? Please can you help

[@DeepakShrivastava]

Thank you. You shy be able to read the choice column value with out error. What error are you getting?

[@kansari36]

Dear Deepak, I am having issue in saving new tasks for reference project. Project information is not saving in SharePoint List while creating new task. Please help

[@DeepakShrivastava]

Are you getting any error? Make sure you setup the project dropdown correctly as i explained in video.

[@AXCELRATOR]

Can you help me please

[@felipe-andre]

Can you please share the .msapp?

[@nandinigowda6674]

Hi Deepak I have the requirement bit different from what you showed , How can I contact you?