Power Apps

Answered

Patching Radio Buttons

(0) Share

Report

Posted on by GF-02121351-0

239

Hi,

I have a Travel Reimbursement app that I am working on and am having a hard time getting the meals patch to work.

I keep getting the error "Expected Boolean"

I am trying to have the cost column value update based on what is selected.

If(MealOpt.Selected.Value = "Breakfast: 6AM-8AM", Patch('TR Expenses', LookUp('TR Expenses', TravelID),{Cost: "$6.00",}),
MealOpt.Selected.Value = "Lunch: Noon-2PM", Patch('TR Expenses', LookUp('TR Expenses', TravelID),{Cost: "$11.00",}), 
MealOpt.Selected.Value = "Dinner: 6PM-8PM", Patch('TR Expenses', LookUp('TR Expenses', TravelID),{Cost: "$19.00",}), 
MealOpt.Selected.Value = "All 3 Meals: 6AM-8PM", Patch('TR Expenses', LookUp('TR Expenses', TravelID),{Cost: "$36.00",}) 
)

Thank you

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (15)

Answers (1)

AhmedSalih

6,680 Moderator on at

Like (1)

Report

Copy link

Link copied!

Hello, @gfeldhake, What is the formula that you are using in the Lookup function to update records?

LookUp('TR Expenses', TravelID=?),{Cost: "$6.00",})

Or you are trying to create new Records? You will have to use the Defaults function in the Patch to create new records.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

GF-02121351-0 239 on at

Like (0)

Report
Copy link

Link copied!

I was trying to make sure that the Meal amount would be tied to the current TravelID. To be honest I Googled how to do this Patch and the I was the code had the Lookup.

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (1)

Report
Copy link

Link copied!

@gfeldhake, Where are you listing the Current TravelID in the Canvas App? Are you using a Gallery?

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (0)

Report
Copy link

Link copied!

It is created on the first screen, and yes, I have a gallery.

Here is my gallery setup:

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (1)

Report

Copy link

Link copied!

@gfeldhake, then your Lookup should be something like this:

LookUp('TR Expenses', TravelID=Gallery.Selected.TravelID),{Cost: "$6.00",})

Make sure to select a record in the Gallery before you run the Patch formula.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

GF-02121351-0 239 on at

Like (0)

Report
Copy link

Link copied!

I think that will work.

I did get this error when I made the change:
crae8_cost is set as a decimal in my Dataverse table.

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (1)

Report

Copy link

Link copied!

@gfeldhake, use the numbers in your Patch functions without double quotations and without dollar sign $.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

GF-02121351-0 239 on at

Like (0)

Report
Copy link

Link copied!

I am starting to wonder if I need to start over and research Radio buttons and If statements more.
I am now getting invalid argument type Boolean. Expecting a record value instead.

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (1)

Report
Copy link

Link copied!

@gfeldhake , are you saving those values in a a column using Choices in Dataverse?Lunch: Noon-2PM

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (0)

Report
Copy link

Link copied!

No, only the amount we pay out (cost) when travel occurs during that time. On a different screen they input their start and end time.

Do you think I should?

Was this reply helpful? Yes No