Canvas App : Button - Claimed for foster

[elyne]

Hi ,

I am not sure if I understand the requirements for the canvas app correctly.

So from my understanding we have to

1. create a list with all the shelters and when selecting a shelter, we see the associated animals that are ready to foster.
2. when then selecting one of those animals with shelter status "ready to foster", we should be able to enter foster name, foster date and integrate a button that changes the shelter status from "ready to foster" to "claimed for foster" , correctly?

how can you do this using a button and not a edit form with the choice field where you theoretically could choose all shelter status? using a button requires a cloud flow in the background to change the shelter status , am I correct?

but this cloud flow is not required, only the email sending cloud flow is in the requirement.

can anyone help how you did this?

thank you a lot!!

[simmo69lol]

Howdy

To change the table with the button you can use the "Patch" function rather than a cloud flow.

The patch function can add in the fields on the form to your table & change the shelter status.

If you have any questions feel free to ask

Patch function - Power Platform | Microsoft Learn

[elyne]

Thank you @simmo69lol 

I am struggling now with the patch formula.

I created a screen where you land when selecting the animal from the list.

then I added a editForm with the fields

"date for foster" and "foster Claimer".

when clicking on the button I now want to add this information PLUS set the shelter status to "claimed for foster".

how does this work?

i tried different patch formulas but always have an error message. see image of form.

[simmo69lol]

The Patch formula can be tricky to get right. I approached it differently, allowing the foster family to enter their details and create a new row in the Foster Family Information table instead of looking up existing ones.

(I noticed there were duplicate Foster Families with different FF numbers in the data.)

Here’s what I did with it, which might help:

Set(RecordResult, Patch('Foster Family Information Tables', Defaults('Foster Family Information Tables'),
{
Name: DataCardValue10_1.Value,
FosterClaimerName: DataCardValue10_1.Value,
FosterLocation: DataCardValue12_1.Value,
LocalShelter: LocationSelected,
JoinDate: Today(),
Email: DataCardValue1.Value
}
));

Patch('Animal Tables', Gallery1.Selected,
{
'Shelter Status': 'Shelter Status'.'Claimed for Foster',
'Foster Claimer': RecordResult.FosterID
});

To break it down:

• The first Patch creates a new row in the Foster Family Information table based on the information entered in the form.
• The second Patch updates the Animal Tables to 'Claimed for Foster' and adds the FosterID to that animal.

The Set(RecordResult, is used to save the row information created in the first Patch so I can use the FosterID in the second Patch since it’s an autonumber generated. It’s not necessary, but variables can be quite handy.
Understand variables in canvas apps - Power Apps | Microsoft Learn

[simmo69lol]

If you post an image of your formula and the error might be able to help

[mcofuzor]

{
'Shelter Status': 'Shelter Status'.'Claimed for Foster',
'Foster Claimer': RecordResult.FosterID
});

The foster claimer is  a lookup, so patch is not working because its a different data type with RecordResult.FosterID. Did it work for you?

[elyne]

@mcofuzor @simmo69lol thanks guys for your help.

Well , I want to submit the 2 fields of the editform (date of foster and foster claimer) as well as the shelter status = claimed to foster, but this field I have not included in the editform but should be transmitted when submitting the edit form submission.

The datasource of the editform is "animals" and the Thitsistem ist "accountVal", because I am referring from a  gallery to this editform. I want to submit the changes of the editform of this given animal and also the shelter status.  So I would enter the formula in the editform (FosterFormAnimal) in OnSelect:

Patch(Animals,{Animals:'FosterFormAnimal'.LastSubmit});

Patch(Animals,'Shelter Status (Animals)'.'Claimed for Foster');

Refresh(Animals);Navigate('StartScreen');Notify("you have succesfully fostered an animal",NotificationType.Success)

maybe I am totally wrong with this formula but I don't know how to do it.

can you help me? 🙂

[evahas]

It looks like you might be missing the record that is being updated in your patch formula,

This is what worked for me: Patch(  Animals,    FosterMe, {FosterLookupCol: FormFosterFam.LastSubmit})

FosterMe is a variable that I set that refers to the record that needed the update.

[elyne · Accepted solution]

@evahas @mcofuzor @simmo69lol  thanks a lot for your support.

I finally have my patch formula working and the EditForm as well as the shelter-status "claimed for foster" is working! woop wooop! sooo excited! 🙂

I finally got it by the advice of @Corry ! (many many thanks)

https://powerusers.microsoft.com/t5/Power-Up-Final-Challenge/THE-PATCH-FUNCTION-KEEPS-GIVING-ME-DIFF... 

I used the formula:

Patch(

    Animals,

    LookUp(

        Animals,

        Animals = FosterFormAnimal.LastSubmit.Animals

    ),

    {'Shelter Status': 'Shelter Status (Animals)'.'Claimed for Foster'}

);

Refresh(Animals);Navigate(StartScreen);Notify("you have succesfully fostered the animal",NotificationType.Success);

SubmitForm(FosterFormAnimal)

The green highlighted part navigates back to the HomeScreen once submit the form.