Unanswered

RadioButton and Patch SP List

(0) Share

Report

Posted on by Cmugford

Not sure what I'm doing wrong, all my fields write except my radio button. I have other apps, where it works, but the other app had score values so written a bit differently, but I get no errors on submit.

Patch(
'Project Time Tracker',
Defaults('Project Time Tracker'),
{
'Name of Professional': DataCardValue17.Selected,
'Project List': Radio1.SelectedText,
'Date of Work': DataCardValue18.SelectedDate,
'Hours Spent On Project Today': Value(DataCardValue19.Text),
'Summary of Work Items Performed': DataCardValue20.Text
}
);

Categories:

Building Power Apps

All responses (9)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RoxyRoller

SelectedText is a deprecated property and should not be used.

Is project list a choice column or text?
Cmugford 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy, it's a choice (via Radio Button) - I started with a drop down and couldn't get that to work, so went with Radio Button as I have done that in another app (that I think I actually think you helped me with haha). But stuck again.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@RoxyRoller

If the data column then is a Choice column, then the formula can be changed to the following:

Patch('Project Time Tracker', Defaults('Project Time Tracker'), { 'Name of Professional': DataCardValue17.Selected, 'Project List': Radio1.Selected, 'Date of Work': DataCardValue18.SelectedDate, 'Hours Spent On Project Today': Value(DataCardValue19.Text), 'Summary of Work Items Performed': DataCardValue20.Text } );

However, I notice that you are referencing datacardvalue controls...this implies you have a form. In which case, you should not be using a Patch at all. You Should be using a SubmitForm on your form. Is there any reason for the Patch?
Cmugford 43 on at

Like
a
(0)

Report
Copy link

Link copied!

No, other than I'm just winging it and learning as I go... using you tube videos as my guide every time I attempt to build a small app when required. What is the difference/use for Patch?
Akash17 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Patch(
'Project Time Tracker',
Defaults('Project Time Tracker'),
{
'Project List': Radio1.Selected.value
}
);
Cmugford 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy, I updated it, but the choice chosen, still won't flow to the SP list.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RoxyRoller

Well, the Form is one of the more powerful features/controls in PowerApps. It provides a tremendous amount of functionality and features that would take you a long time to try and build yourself.

Doing a Patch is only a very small part of what a form does, so, using a patch completely wastes all that the form brings to you. Plus, the form is highly simple to use as opposed to the complexity of building your own patch statement.

I would stick with the form and use the SubmitForm on your form.

In this case, make sure your Update property on the DataCard for the Project List field is what you need it to be.
Cmugford 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Akash17, I did try that as well already, but it gives me an error
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@RoxyRoller

Yes, that suggestion will not work on a Choice column.