Show one form data in another form's data card

(0) Share

Report

Posted on by rameshmukka

1,110

I have a crazy requirement to show values of form2 in few data cards of form1.

I have List1(primary) and List2(Secondary). List2 is referencing List1 with List1's ID column. I have named it as "OTJ ID" in List2. OTJ is my primary list (List1). List1 has 8 columns which are questions. Each question has 4 drop downs to show so I went to create another list (List2) to have 4 different columns which are drop downs with values Poor, Average, Good, Very Good, Excellent. Now I want to show one question from List1 in form1 followed by 4 different drop downs from form2 under that question. Like wise I would like to repeat for remaining 7 questions and their drop downs from 7 different secondary lists. Something like shown below.

I first created form1 and form2 at same level and tried copy-paste form2 into the data card of form1. It doesn't paste. I felt it doesn't work that way. What other solutions I have for my requirement?

Categories:

Connecting to Data

I have the same question (0)

All responses (4)

Answers (0)

v-jefferni on at

Like (0)

Report
Re: Show one form data in another form's data card

Hi @RameshMukka ,

Could you please share more details about your scenario? Which column types are those columns of List 1?

I think your scenario is something like a survey project:
List 1 with 8 columns of questions which are names of the columns.
Each column have 4 dropdowns to show the answers.
Lists 2-9 are corresponding to the columns of list 1 and each one with 5 columns, one looks up list 1 ID and the other 4 are Choice type columns with 5 choices in each.

Am I right?

If you do, I made a test on my side and please follow the steps below:
1. Unlock the data cards in your form1.
2. Select the data card of question1, insert 4 Combo Boxes and 4 Labels.
3. Set the Labels’ Text property to the column names of the secondary list.
4. Set each Combo Box’s “DefaultSelectedItems” to

LookUp(List2, ‘OTJ ID’.Value=Gallery.Selected.ID).List2ColumnName

5. Set each combo box to not allow multiple selection and not searchable.
6. Set Items property of combo box to Choices(List2.ColumnName)
7. Set OnChange of the first three combo boxes in the Card to:

Patch(List2,If(IsBlank(LookUp(List2,‘OTJ_ID’.Value=Gallery.Selected.ID)),Defaults(List2),LookUp(List2,‘OTJ_ID’.Value =Gallery.Selected.ID)),{List2ColumnName:Self.Selected})

8. Set OnChange of the last combo box to:

Patch(List2,If(IsBlank(LookUp(List2,‘OTJ_ID’.Value=Gallery.Selected.ID)),Defaults(List2),LookUp(List2,‘OTJ_ID’.Value =Gallery.Selected.ID)),{List2ColumnName:Self.Selected}); Patch(List1,ThisItem,{'Question1':Concatenate(Text(ComboBox1.Selected.Value),";",Text(Self.Selected.Value))}) //here you will have to add 3 combo box selected value and the self-selected value of last combo box

9. Hide all those secondary list Title columns.

When it’s operating, looks like below:

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
rameshmukka 1,110 on at

Like (0)

Report

Re: Show one form data in another form's data card

Sorry if there is a lack in my question not giving you enough clarity. I do not have a gallery. But I ended up doing everything without any form or gallery. Individually adding controls on the screen and patching them at the end to my SharePoint list. I felt using forms is not best of doing this. I had to switch my way.

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Re: Show one form data in another form's data card

Hi @RameshMukka ,

Using Galleries and Forms is normally a simply since you could quickly retrieve the data and place them where you want. You could also made this with Individual controls but have to define data sources of each control and if you want to update the record, it would be a complex formula since you would have to update contents in all of the controls.

In short, the method is common but different in retrieving and updating data.

On your side, since you have quite a few question fields to patch to SharePoint list, I don't think that using individual controls is a good method which would leads to a large amount of formula typing work.

Best regards,
Community Support Team _ Jeffer Ni

Was this reply helpful? Yes No
rameshmukka 1,110 on at

Like (0)

Report

Re: Show one form data in another form's data card

I understood your point of view. The scenario is only for submission and we are not updating or modifying them back. The dropdown values for each question have to be captured on new submission. So I had to create 4 drop down columns for each question. So 8 columns for questions and 8*4(32) columns for drop downs. I dont see a need of gallery here as am not editing or updating any record here. I tried taking different SharePoint lists for drop downs by creating a relationship with Parent list IDs but I didnt find a way to insert one form(secondary form with drop downs) into another form(questions form). So I had to go with individual controls on the scrollable screen.

Was this reply helpful? Yes No