Get data from sharepoint list but create new Item in other Sharepoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello fellow powerapps users !

I need your help, because i was not able to find the answer to my terrible question :

Context :

I am creating a powerapps that will display a contact form to my Sharepoint users.

This form is quite simple :

the user will have to choose a category of retail store, then the geographic store itself, and then the department he wants to reach. He will have to write his message and then send it.

(The store is a dropdown , dependant of the category chosen. The department is a simple dropdown filled with static departments)

This form will create a new item in a Sharepoint List and that will trigger a flow : an email will be send to the specific department chosen by the user.

What i already did :

- I've created a SharePoint list called Contact Form Param which contains : each store's details (category, physical address, and every department's email address)

- I've created a SharePoint List called Contact Forms which will contain every form sent by the user . These forms will consist on : Category, Store, Department chosen and Message.

- I've created a powerapps with fields populated with Contact Form Param list. (see attachment)

What i want:

I would like to know :

How i could link my "Send" icon to my Contact Forms list, so that it creates a new item in it, getting the chosen values in my powerapps form to fill the right fields/columns in Contact Forms list?

Is it a Property or an advanced option of my button/icon ?

Should i rethink entirely my process ? Should I create my Powerapps from my Contact Forms list ? (but if so, how will i be able to get my datas from the other list ?)

Please, i'd really appreciate your help ! Thanks !

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-monli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

To get data from another list and update the current list, you should use Lookup column type from SharePoint list.

This means that you should create lookup columns in your Contact Forms, and when you create the lookup column, select to Get the information from Contact Form Param list. Then specify with column to be included in current column, Additionally, you can also add other columns from Contact Form Param list by checking the chechboxes below.

After this, you should use Contact Forms list to auto-generate the app, and add those lookup columns to Forms.

Regards,

Mona

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Solved !
I saw @v-monli-msft answer after unfortunately, but she gave me quite a good answer 🙂
We did quite the same process idea as she proposed, just not via SP lookp columns.

Here is how i solved it :
I insterted custom controls, on which in Items property, we set
Distinct('Contact Form Param';Category)
then, for depending values in other field, something like that :
Distinct(Filter('Contact Form Param'; Category=ddlCategory.Selected.Value);Concatenate(StoreNum;" - ";Title))
And finally, on the IconAccept image control, i just used Patch() on the OnSelect property like this :
Patch('Contact Form';Defaults('Contact Form'); { Title: ddlCategory.Selected.Value;Store:ddlStore.Selected.Value;Message:ddlQuestion.Text})
Now I just have to manage Cancel button and Exit() function. 🙂

Thanks again @v-monli-msft for your time, I hope our answers could help future powerapps explorers !

Was this reply helpful? Yes No