Multiple choice fields; one updates the other in two different sharepoint lists

(0) Share

Report

Posted on by Masakichi123

Hello everyone,

I have a question:
I have a power app with two Sjarepoint lists (A and B).

List A collects all skills that exist; List collects all selected employee skills. Both lists have a "Tags" column. Both are multiple choice columns.

If the tags of a skill are adjusted in list A, they should also be updated in list B. Lookup does not work with multiple choice columns. How can I solve this?

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Masakichi123 ,

Could you please share more details about your scenario? What's the relationship between the two lists?

I assume list A has skills as entries, tags for each skill, and then in list B there would be multiple skills of the selected employee. If the skills column in List B is a LookUp column, then I don't think the tags column that should be an associated LookUp column need to be modified.

Best regards,

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-jefferni,
thanks for your answer!

Yes that is correct:
List A has skills that have multiple tags associated with them. List B shows all skills that an employee has selected and who thus adopts the tags for the skills.
Now, if someone changes the tags on a skill in list A, they won't be updated in list B. It's basically a 1:n relationship (at least I think so, i am a newbie):
For example, if the tags "slurp" and "cup" exist for the skill "drink coffee" and "cup" is now deleted, then "cup" would have to be deleted everywhere in list B for the employees who have "drink coffee" as a skill.
From my point of view, this would work best with Lookup - but because it's a multiple choice field, I can't use it for a Lookup column.

Do you know how I can solve this?

Thanks in advance!

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

Like (0)

Report
Copy link

Link copied!

Hi @Masakichi123 ,

So, in list B, one employee as an entry can have multiple skills, and each skill has multiple tags in list A, there is also a tags column in list B where you need to sync with list A skill tags, is this the case?

Best regards,

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni

yes that is right.

Best regards

Was this reply helpful? Yes No