Unanswered

Edit Combo Box selections read in from a Gallery

(0) Share

Report

Posted on by cgreene007

I have an app in PowerApps that uses two SharePoint Lists. One SP list populates a Combo Box in the app. The other SP list is where "records" from a questionnaire are saved. That questionnaire has the Combo Box where one selects from 1 to 5 selections.

Question is how to read back the saved data from the questionnaire SP list if I want to edit those Combo Box selections from the questionnaire?

Any guidance is appreciated.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

rpersad 831 on at

Like
a
(0)

Report
Copy link

Link copied!

If you would like to edit a record from the Questionnaire SP list you can just add an Edit form, set the Data Source to the SP list and set its item property to Gallery.Selected
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @cgreene007,

Could you please tell me that if two SP lists shares a same column including 1 to 5 selections?

How you edit the saved data from questionnaire list? Using a form or standalone controls?

Do you have 2 lists set as below?

list1:

Title(Text type?)

1

2

3

4

5

list2:

Title(Text type?) Questions

1 a

2 b

3 c

4 d

5 e

If so, I think you want to edit the record through numbers you select from the ComboBox, right?

If you also have an edit form based on questionnaire list, once you select from the Gallery where you have 1 to 5 selections, you could set the Item property of the edit form as below:

LookUp(questionnaire_list, Title=Gallery.Selected.Title)

Then you could edit the other fields in your form.
cgreene007 4 on at

Like
a
(1)

Report
Copy link

Link copied!

HI and thank you for all the replies. I find that I should add more clarity as to what I have so far.

The two SharePoint lists both save all data as string data type.

The SP list which has the combo box items save each item in its own record as type string.
WorkTypesList:
Name | Title
1 work work
2 play play
3 clean clean
etc ...
Same for the SP list which saves the questionnaire data - all of it are string data type.
WorkTypesList column
clean, play

So the Combo Box values that are selected in the questionnaire are saved as comma delimited text strings.
Question: Should the SharePoint Lists, both of them, ( or the questionnaire SP List alone ), have the WorkTypeList column defined as combo box?

Also, I am not using a control form in Power Apps, but rather, I'm using PATCH function for all of it.