Answered

patching to sp list from gallery input controls

(1) Share

Report

Posted on by ess1

i have a form along with multiple galleries that are not connected to a data source but contain input controls (see image below). the number of inputs in the gallery is controlled by the number dropdown at the top of the screen.

the information at the top of the screen is standard for all records i am looking to patch and the information gathered from the galleries will be different at each patch.

when i try using the following code to patch, the results from the galleries does not change even though i am selecting a different item in the gallery each time. in other words, the patched results only are 3 records all with the same information.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi,

Hopefully I am following but you are putting 3 record in (based on your example) and half the data comes from the gallery and is different and half comes from the top.

Then do this.

ForAll(Gallery.AllItems, Patch(TheSource, Defaults(TheSource), { MyFieldFromTop: TopField.Text/ValueWhatever, MyFieldFromGallery: ThisRecord.MyGalleryControl.Value/Text etc } ); And done

Was this reply helpful? Yes No
Verified answer

ess1 31 on at

Like (1)

Report
Copy link

Link copied!

that was super helpful! yes half the record comes from the top half of the screen and the other half from the galleries on the bottom half

it works when i am patching only one gallery. is there anyway to patch all the galleries at once? for reference there are 7 different vertical galleries.

Was this reply helpful? Yes No
ess1 31 on at

Like (1)

Report
Copy link

Link copied!

I moved them all to one gallery. thank you @FLMike!!

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

If you can please mark my answer as the answer I would appreciate it.

Was this reply helpful? Yes No
ess1 31 on at

Like (0)

Report
Copy link

Link copied!

@FLMike

How can i make all the fields in both the gallery and form required?

working on the display mode of the submit button ive tried the following:

If(!DailyCrewForm.Valid || (IsBlank(CrewLeadCombobox.Selected.DisplayName) || IsBlank(FTENumberInput.Value) || IsBlank(CrewCodeInput.Value) || IsBlank(PhoneInput.Value) || IsBlank(StartTimeInput.Value) || IsBlank(EndTimeInput.Value)), DisplayMode.Disabled, DisplayMode.Edit)

this worked but it only applied to the first row of the gallery so if the user is trying to input 2 or more, only the first needs to be filled out for the submit button to be clickable

i then tried testing this out but received the error "expected enum value"

ForAll(CrewInfoInputGallery.AllItems,

If(IsBlank(ThisRecord.CrewCodeInput.Value),

DisplayMode.Disabled,

DisplayMode.Edit))

Was this reply helpful? Yes No