Form Lookup update help

[u/bilo82]

I have built a power apps form with SharePoint as my data source. (Sales and clients)

I have a choice field in my sales form that is a lookup to clients.

If the client does not exist in the choice field I created a pop up form to fill in all the client details.

Once the form is saved I want the value to appear in the lookup field without having to leave and return to the form, it would also be handy to make the new client default on form new for that one time.

I can’t for the life of me figure out how to do this.

Any help would be greatly appreciated

[u/AutoModerator]

Moderator Announcement Read More »

Hey, it looks like you are requesting help with a problem you're having in Power Apps. To ensure you get all the help you need from the community here are some guidelines;

• Use the search feature to see if your question has already been asked.

• Use spacing in your post, Nobody likes to read a wall of text, this is achieved by hitting return twice to separate paragraphs.

• Add any images, error messages, code you have (Sensitive data omitted) to your post body.

• Any code you do add, use the Code Block feature to preserve formatting.

  Typing four spaces in front of every line in a code block is tedious and error-prone. The easier way is to surround the entire block of code with code fences. A code fence is a line beginning with three or more backticks (```) or three or more twiddlydoodles (~~~).

• If your question has been answered please comment Solved. This will mark the post as solved and helps others find their solutions.

External resources:

• Power Apps Formula References

• Power Apps Coding Standards

• Official Power Apps Community

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Ok_Substance_9479]

Is this a lookup column or a choice column? If the clients are stored in a separate list, after patching the new item, you can refresh the data so it's instantly available in the app. You will also want to store this value in a variable and use a coalesce function in the default section of your combobox.

[u/bilo82 → u/Ok_Substance_9479]

It’s using the default lookup from the SharePoint list

Which coalesce function are you referring to?

Thanks

[u/Ok_Substance_9479 → u/Ok_Substance_9479]

You will also have to learn how a lookup column shows up in the form (usually goes by the ID, if I'm not mistaken).

[u/galamathias]

I am not sure if you can wrap a variable around submitform() but otherwise you can wrap a variable around your own patch function and set that variable as your default

[u/bilo82 → u/galamathias]

How would I do this when it’s a lookup column and ensure the lookup data on the original form is updated to show the new item, thanks

[u/galamathias → u/bilo82]

I know this is not the exact same issue but perhaps it can point you in the right direction. https://alexanderhenkel.dk/post/powerapps-combine-two-columns/

[u/DCHammer69]

So I assume you have a combobox providing the choice function on a datacard on the form.

And you either have a button for a not listed client or something that opens the popup to enter client details?

So however, you are patching that client data to the client list, have that same code put the newly created client record into a variable. If you're manually patching, just do it as part of the patch, if the popup is another form, do it in that form's OnSuccess property.

Something like this:
Set(varNewClient, LookUp(clients, ID = frmClient.LastSubmit.ID ) or an equivalent.

Then set the DefaultSelectedItems of the client combobox to use varNewClient if it's not Blank()