Update Sharepoint Library if Exists, if not create new item

(0) Share

Report

Posted on by Sirbatchu

Hi All

Really hoping I can get some help, I am going crazy with this.

I have a Sharepoint List, as the database for 2 seperate galleries (Each one has a filter for Bob or Gaj) which are nested in a larger gallery(This is a simple Month Calendar ForAll Sequence), the issue I have is I am unable to select the nested gallery item as the gallery.selected.value. as the dropdown control does not exist in the 2 nested galleries. I have this semi working that when an item is existing it will update the value appropriately, specifically the value in the calendar item in the blue square. However it will not "Create" a new entry in the specific "Day" entry.

Here is the "Onchange" property of the Dropdown,

"

If(
    IsBlank(
        LookUp(
            'Course Calendar',
            'Class RN' = gal_Calendar_Events_3.Selected.'Class RN' & 'Course Start Date' = ThisItem.Value
        )
    ),
    Patch(
        'Course Calendar',
        LookUp(
            'Course Calendar',
            'Class RN' = gal_Calendar_Events_3.Selected.'Class RN' & 'Course Start Date' = ThisItem.Value
        ),
        {
            'Assessor Status': DropdownCanvas3_1.Selected.Value,
            'Course Name': DropdownCanvas3_1.Selected.Value,
            Assessor: {Value: "Gajender"},
            'Off Date': ThisItem.Value,
            'Course Start Date': ThisItem.Value,
            'Course End Date': ThisItem.Value
        }
    ),
    Patch(
        'Course Calendar',
        {
            'Assessor Status': DropdownCanvas3_1.Selected.Value,
            'Course Name': DropdownCanvas3_1.Selected.Value,
            Assessor: {Value: "Gajender"},
            'Off Date': ThisItem.Value,
            'Course Start Date': ThisItem.Value,
            'Course End Date': ThisItem.Value
        }
    )
);
Refresh('Course Calendar')
"
 
Any help would be massively appreciated!

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
hey

can try this :

Set(varItemToFindOrCreate, LookUp( 'Course Calendar', 'Class RN' = gal_Calendar_Events_3.Selected.'Class RN' And 'Course Start Date' = ThisItem.Value ) ); If( IsBlank(varItemToFindOrCreate), Collect( 'Course Calendar', { 'Assessor Status': DropdownCanvas3_1.Selected.Value, 'Course Name': DropdownCanvas3_1.Selected.Value, Assessor: {Value: "Gajender"}, 'Off Date': ThisItem.Value, 'Course Start Date': ThisItem.Value, 'Course End Date': ThisItem.Value } ), Patch( 'Course Calendar', varItemToFindOrCreate, { 'Assessor Status': DropdownCanvas3_1.Selected.Value, 'Course Name': DropdownCanvas3_1.Selected.Value, Assessor: {Value: "Gajender"}, 'Off Date': ThisItem.Value, 'Course Start Date': ThisItem.Value, 'Course End Date': ThisItem.Value } ) ); Refresh('Course Calendar');

cheers

Was this reply helpful? Yes No
Sirbatchu 71 on at

Like (0)

Report

You sir are a genius

it 100% works.

The only issue I have now is the time it is taking to "Refresh" good 5 or 6 seconds.

Not sure if there is anything I can do about this, as technically its refreshing around 60 "Nested" galleries at once.

Any ideas, but thank you so much for the resolution this has done it!

Was this reply helpful? Yes No