Connect Form To Two Sharepoint Lists

(0) Share

Report

Posted on by dahlgebra

119

Hi.

I have made a form that is based on a Sharepoint list that should be filled out and then be submitted to the same list. However, one of the fields that should be filled out is a choice box. That particular field should be linked up to another Sharepoint list that defines what choices that user can choose. Is it possible to achieve that by only using one form?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

Hi @dahlgebra ,
Absolutely - just connect the other data source and base the Items property of the DropDown/ComboBox on the field in the other list.
Happy to assist if you give me more details such as the List and field name and type of field.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
v-yutliu-msft on at

Like (1)

Report
Hi @dahlgebra ,

Do you want to get data from one list and update the record to another list?

If so, this is possible.

Firstly, you need to connect your app with these two lists.

Secondly, set the form's data source to the list that you want to update to.

Thirdly, unlock the field that you want to be linked up to another Sharepoint list.

Customize this field. For example, insert a drop down in the datacard, set the drop down's Items:

Distinct(linked list,filed name)

Do not forget to customize this field's datacard's Update property.

You need to fill in formula based on field data type that you want to get data from and the field data type that you want to update to.

If you still have problems, please tell me the fields data type in two lists , and what data that you want to display in that particular field ?

Best regards,

Was this reply helpful? Yes No
dahlgebra 119 on at

Like (0)

Report

Thanks, I figured it out.

Now the drop down box only shows items that is defined in this SP-list: "Prosjektvelger": "Choices(Prosjektvelger.'Name 1')". In order to make this logic dynamic, i would like to replace "Name 1" with the user's name. I am familiar with the function: user().FullName, but i have not figured out how i can implement it in the code.

Thanks in advance

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (0)

Report

Hi @dahlgebra ，

I'm very glad that you've solved your problem!😀

Do you have any other problems?

If not, could you change your issue's status to "Answered"?

Thanks!

Best regards,

Was this reply helpful? Yes No
Valencia 2 on at

Like (0)

Report

I have two Sharepoint List -
The column Function Reporting Grouping is a lookup to the main list FY22 DNA Click Data
I have tried doing :
What should I mention for the update property of this data card?
I saw a video where they mentioned this:
I am not sure what should it be :
My file from where the column I am referencing is

Problem:All field entries are filled from powerapps to sharepoint except this lookup column doesnt get any value back

Was this reply helpful? Yes No