DefaultSelectedItems not submitting

(0) Share

Report

Posted on by R Bakker

725

Hi all

In my combobox in my form while in Edit mode,I tried this LookUp('App Functions',Functions.Value = GalleryFunction.Selected.Title) which doesn't give errors, but it does not set the DefaultSelectedItems either. Functions is a lookup column, whereas GalleryFunction.Selected.Title is sourcing from the actual list that has the data.

Data source is Sharepoint list.

The objective is when I select a record in the GalFunctionSelect gallery that I navigate to my form to enter a new record, but that my combobox is preselected, and when I hit submit button that it saves the default selected item along with the other fields that I have filled out to my Sharepoint list.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi @Corissandageri ,

As the Functions is a lookup column, the combobox Items property should look like:

Choices([@'App Function'].Functions)

What you provide as DefaultSelectedItem to the same combobox control is an entire row from 'App Functions' that is not quite similar with the Items provided.

Your problem will be solved, if you use the following:

LookUp(Choices([@'App Function'].Functions),Value=GalleryFunction.Selected.Title)

Hope it helps !

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Hi gabibalaban
This works perfectly, now that I know, it seems obvious. Thank you for your time.

Was this reply helpful? Yes No
JHS2019 30 on at

Like (0)

Report
Copy link

Link copied!

But are you not missing the true/false statement ? mine does not work

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

What is your scenario?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Have one list called case
Have another list called items

In the items list is a lookup column to the case list, which is an ID column.

I need to use the ID of the case to match the items in the items list, therefore, every time I make a new Item, it should use the ID from the selected case in a gallery.

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

My app has two SP list. In the first list, when a record is generated, the ID column is a ID column, then in my second list the ID column is a lookup to the first list.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It is the same in my case with the two list, where one has the ID and the other one looks up the ID. However

It states 11, but not display in the combobox

Was this reply helpful? Yes No
GustavoSBastos 5 on at

Like (0)

Report
Copy link

Link copied!

Hi, i know its being a while since the first post, but it can help someone who is iniciating in powerapps. In my case i had a person field and i needed to set the logged user as default in the DefaultSelectedItems parameter. Tried to use the function SearchUser from the Office365Users connector but it was not submitted.

So i set the register as a Choice register:
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser";
Claims: "i:0#.f|membership|" & User().Email;
Department: ".";
DisplayName: User().FullName;
Email: User().Email;
JobTitle: ".";
Picture: "."
}

Its all about what the field expects to receive. The power apps has limits of how much registers can search with the lookup function.

In your case try to set as a key-value register like this:
{
Id: Gallery1.Selected.'Case ID #'.Id;
Value: Gallery1.Selected.'Case ID #'.Value
}
Should work..

Was this reply helpful? Yes No
FelipeQuagio 39 on at

Like (1)

Report
Copy link

Link copied!

Almost three years after being published, this helped me, thank you very much. It worked.

Was this reply helpful? Yes No
GustavoSBastos 5 on at

Like (0)

Report
Copy link

Link copied!

I'm glad that worked and helped you!! 🤝

Was this reply helpful? Yes No