Answered

data source one sharepoint list, write to another

(0) Share

Report

Posted on by 11playto16

Hello,

i have one SP list1 where i have collunm "parts", this one i would like to use as soure for combobox which is in SP list2 in editform1

open combobox and choose items which are in collunm "parts.

on the other hand i have Second Sp list2 - collunm "parts1" where i have editform1 and in it i have this combobox - the items of it - SPlist1 and dispaly and search fields are "parts"

i would need to have in combobox - data source - SP list1 - "parts", where i can find items and basically save them to SPlist2 to colunm "parts1"

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @11playto16,

Do you want to populate the ComboBox corresponding to parts1(SPlist2 ) with the parts(SPlist1)?

Actually, if the parts column is a single-line-of-text type, you could format this parts1 column as a LookUp type, so that you could use the parts column values directly in this ComboBox within the EditForm1, just need to set the Items property as:

Choices(SPlist2.parts1)

If you don't want to format this parts1 column as a LookUp type, well, you could set the ComboBox Items property as:

Distinct(SPlist1,parts)

Then set the Update of this parts1 data card as below:

{Id:LookUp(SPlist1,ID=ComboBox.Selected.Value).ID Value:ComboBox.Selected.Value }

Was this reply helpful? Yes No
11playto16 44 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft,
yes i want to populate those two.
Choises(SPlist2.parts1)

this instruction just add me to combobox values from SPlist2, but still when i submitform, i do not have anything saved in SPlist1, Could you also help me with that ?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @11playto16,

"i would need to have in combobox - data source - SP list1 - "parts", where i can find items and basically save them to SPlist2 to colunm "parts1"

You mentioned that you want to save data to SPlist2 instead of SPlist1, please read my reply one more time.

If you have a LookUp column to retrieve parts column values directly from SPlist1 parts column, you need to set the Update property of the part1 data card as below:

ComboBox.Selected

Was this reply helpful? Yes No
11playto16 44 on at

Like
a
(0)

Report
Copy link

Link copied!

i did something previously and forgot to change update property
Now it works,
Thanks

Was this reply helpful? Yes No