cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Patching multi-select lookup column that has existing values

Attempting to emulate this method...

PowerApps Patch Multi Select Fields  

 

Patch is throwing error when values previously selected but not subsequently changed, which I tracked back to blank values in collection for combo box selected items (I am showing row count and Id & Value below - I've substituted "Blank" for Blank().)...

 

MikeSeitz_1-1650313841629.png

 

Here is how I set table variable, and specify DefaultSelectedItems for combo box...

MikeSeitz_2-1650372598587.png

MikeSeitz_3-1650372639069.png

 

 

Here is my code to collect selected items from combo boxes (Strength = ResponseA and Weakness = ResponseB)...

MikeSeitz_0-1650372097548.png

 

Here is my code to patch existing list item...

MikeSeitz_1-1650372163674.png

 

 

Lookup column settings...

 

MikeSeitz_2-1650315234846.png

 

 

 

Any help in understanding how to fix/work around this would be greatly appreciated. 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

I believe I found the issue...

Noticed a mismatch between Items and DefaultSelectedItems...

MikeSeitz_0-1650474999901.png

 

Changed DefaultSelectedItems to...

MikeSeitz_1-1650475058466.png

 

Collections used in Patch now show Id & Value, even if no changes...   (and no error occurs !!)

MikeSeitz_2-1650475334001.png

 

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

I believe I found the issue...

Noticed a mismatch between Items and DefaultSelectedItems...

MikeSeitz_0-1650474999901.png

 

Changed DefaultSelectedItems to...

MikeSeitz_1-1650475058466.png

 

Collections used in Patch now show Id & Value, even if no changes...   (and no error occurs !!)

MikeSeitz_2-1650475334001.png

 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,662)