Answered

Forms choose alternative source for DropDown control

(0) Share

Report

Posted on by UB400

356

I have a Sharepoint List, with most of the Columns being Lookup Columns from other Sharepoint Lists. While this works great, as in the Form working correctly as one would expect with the DropDowns populated correctly, the performance leaves a lot to be desired i.e. everytime clicking on a DropDown, it takes a few seconds to populate the DropDown list.

While I can create Collections locally on the device from the SP lists, is there a way to point the DropDown to the locally stored Collection instead of retrieving it from Sharepoint?

Main reason I chose to use Forms was to get the LastSubmit.ID for the new record created when the Form is submitted. As an alternative is there a way to get the ID of the newly Created ID when using something like "Patch" instead of Forms?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @UB400,

If the dropodwn controls are working with SharePoint Lookup field, then take use of collection may not so easy to make it work.

I think you should already noticed that Lookup field are record type, see the following thread for how to deal with Lookup fields using patch:

How to patch SharePoint List Lookup field, such as people, choice, or the custom Lookup column type

The example of the Lookup field in PowerApps is as below:

{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id :8, Value :"235" }

Further, to get the newly created ID field, I think it is better to use the Form.LastSubmit property, as other methods would need to start a new query to get the updated record.

Regards,

Michael

Was this reply helpful? Yes No
UB400 356 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-micsh-msft thanks for the response, I'm familiar with using Patch with lookup records, I was just hoping that there was a way to retrieve the ID of the newly created Record in a similar fashion as LastSubmit for Forms.

Is there a way to point the DropDown column in a Form to another Source rather than the original list that the Form is associated with? Basically I'm trying to improve the performance, currently clicking on the drop down takes time to load the options in the Dropdown.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@UB400, Patch returns back the item created and the only way to access it is to collect it at the moment of the patch.

So the formula would be something like this:
Collect(createdItem, Patch(Destination, Defaults(Destination), { column1: value1, column2: value2 }))
After that your 'createdItem' collection should contain the entire object created and you should be able to access what info you need from there.

Was this reply helpful? Yes No
UB400 356 on at

Like
a
(0)

Report
Copy link

Link copied!

@AnonymousYou're a GENIUS! That is awesome, thank you so much. In one fell swoop, you've eliminated one of my biggest headaches!

Was this reply helpful? Yes No