Save PowerApps Form Data to Multiple SharePoint Lists

Подписаться 10 тыс.

Просмотров 24 тыс.

50% 1

This video will walk the process of how to save PowerApps form data to multiple related SharePoint Lists with one click. So stay tuned and lets go to the demo after this short intro.
I will use two SharePoint lists for this demo Clients and Projects. Both lists are connected via a lookup column (Project list have a lookup column called Client).
In PowerApps I will create a form to enter new client data as well as project data. On button click, first the client record will be created in the clients list and I will retrieve the client id which I then pass to the project list record client lookup column. This way when a project records get created, it automatically has the correct client assigned.
★ TABLE OF CONTENTS ★
• 00:00 Intro
• 1:40 Create the Canvas app in PowerApps Studio
• 2:16 Connect to Multiple SharePoint Lists in PowerApps Studio
• 02:53 Create Input Screen in PowerApps
• 04:28 Add logic to Save PowerApps From to Multiple SharePoint Lists
• 08:14 Outro & Subscribe
🔴 ** BE OUR FRIEND **
✅ Website: www.keapoint.com
✅ LinkedIn: h / 18782324
✅ Twitter: / kea_point
✅ Facebook: / keapointuk
🔎 HASHTAGS 🔎
#PowerApps
#SharePointLists
#CanvasApp

Опубликовано:

20 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 30

@iyengar007 3 года назад

This was short and to the point. appreciate your efforts

@KeaPointTechTips 3 года назад

Glad you liked it

@tolgaoy7957 2 года назад

Thank you, very clear explanation. Other videos and guides I found are so long and they try to explain everything in a big project.

@KeaPointTechTips 2 года назад

Glad it was helpful! I try to tailor my videos for new citizen developers.

@ronbakker1300 2 года назад

Thank you this would be very handy for bigger projects.

@KeaPointTechTips 2 года назад

Thanks Ron

@jray1429 3 года назад

Thank you…This is helpful and presented good I like your intro too 😀

@KeaPointTechTips 3 года назад

I'm glad you like it

@mohamednasr5444 Год назад

Hey man, Thanks amazing and helpful but i have one quastion what about when i edit an item in the first list update the second? And when i delete an item in first list delet the same item in the second list Thanks a lot i wish you can answer my question

@nathankirui796 Год назад

Thanks a lot, now suppose I want to create multiple list items from one form submission, with a button "add"?

@KeaPointTechTips Год назад

You need to use patch function behind that button

@alennanew4295 Год назад

Hi do I need to create any lookup column in sharepoint for the code to work?

@stefanpinezka4302 2 года назад

Hi, Is there a way to save data to specfic list? For example: from the drop down menu i select a value and basing on the choice i save data to list1 or list2.

@KeaPointTechTips 2 года назад

Yes possible, use patch function inside an if condition.

@drowsy4400 2 года назад

Is it possible to filter the list data? Lets say i have a yes/no question on one list and if the «client» has a «yes» the client is put into a «yes folder» and the rest of the clients remain in the original list

@KeaPointTechTips 2 года назад

You will need to group the data and then send it to the designated library. You can use PowerApps collections to achieve this.

@viruscop2 2 года назад

Hi there great guide, I wonder on the second patch (Projects) there is an error on my side as shows as - The function 'Patch' has some invalid arguments. and The type of this argument 'Client' does not match the expected type 'Text'. Found type 'Record'. Wonder why i got this error...

@KeaPointTechTips 2 года назад

You are trying to patch Record (Object) instead of text. I guess you are missing .Text property

@dupinderkaur5619 Год назад

getting the same error, were you able to resolve this?

@carlangeloladica7674 Год назад

Should I connect first to azure?

@KeaPointTechTips Год назад

No azure connection involve here. It is saving directly to SharePoint list

@ECERaagulLD 2 года назад

how to write the syntax for lookp colum

@KeaPointTechTips 2 года назад

Patch('Lease Tenant Application', Defaults('Lease Tenant Application'), { LookupColumnName: { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:Room_ID.ID, Value:Room_ID.Value} } } A rough guide.

@ECERaagulLD 2 года назад

@@KeaPointTechTips I have done the same what u did for my reference but i got errors on it

@galleon8129 2 года назад

Mine doesn’t work

@KeaPointTechTips 2 года назад

Can you please elaborate on the issue you are facing? Thanks

@galleon8129 2 года назад

@@KeaPointTechTips I sent you a message in your website using the contact form, you’ll see the functions I used.

@galleon8129 2 года назад

@@KeaPointTechTips I used the same example but it still shows errors. I added the two Sharepoint lists too, but the auto suggest brings up ‘Clients’ instead of Clients, it’s the same for the other SharePoint list.

@alierbas72 2 года назад

Set( NewCategory, Patch( Category, Defaults(Category), { Title:TxtCategoryNaam.Text, 'Categorycode':TxtCategoryCode.Text} ) ); Patch( (Product, Defaults(Product), { Title:TxtProductNaam.Text, Categorynaam: { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: NewCategory.Id, Value:NewCategory.Title } } ) Clients -->Category Clientemail-->Categorycode Projects--->Product Client---Categorynaam (lookup) . I get ' Invalid argument Type. Expecting a record value, but of a different schema. Missing column.

@KeaPointTechTips 2 года назад

Looks like some column names not matching. Could be a spelling mistake