Could you please help to check what wrong with the formula?

(0) Share

Report

Posted on by GGG666

180

resolved

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (3)

Sort by

Verified answer

WarrenBelz 154,930 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@GGG666 ,

I had some involvement on this earlier - if you are updating a single record, you are better doing this

With( { wMail: LookUp( 'Home working schedule', Employee.Email = User().Email ) }, If( IsBlank(wMail.ID), NewForm(EditForm1_1), Patch( 'Home working schedule', {ID:wMail.ID}, {OUT_OF_OFFICE:"Yes"} ) ) )

there is no need to set the variable here unless you want to use it later.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
GGG666 180 on at

Like (0)

Report
Copy link

Link copied!

Hi Thanks a lot .Though ,it still have some .

These code is for a toggle. If the toggle is on the column :out_of_office of current user‘s item is yes, or else it is No

Was this reply helpful? Yes No
GGG666 180 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@GGG666 ,

Where did you put that code and what is the Error?

Was this reply helpful? Yes No
GGG666 180 on at

Like (0)

Report
Copy link

Link copied!

Hi WarrenBelz

Toggle's OnCheck

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@GGG666 ,

I thought you might spot that one yourself from the error message (this is a skill you will need) - I only copied your code assuming it had correct values - your OUT_OF_OFFICE is a Boolean field

With( { wMail: LookUp( 'Home working schedule', Employee.Email = User().Email ) }, If( IsBlank(wMail.ID), NewForm(EditForm1_1), Patch( 'Home working schedule', {ID:wMail.ID}, {OUT_OF_OFFICE:true} ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
GGG666 180 on at

Like (0)

Report
Copy link

Link copied!

Hi WarrenBelz
Thank a lot.
In fact , I tried to switch the column to Text before. Now it is Choice Type.
Though, it still have error.

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@GGG666 ,

Please post any relevant changes you have made as these assist greatly, especially ones you have made since the last post (it was looking for a Boolean value). Assuming your choices are Yes and No

With( { wMail: LookUp( 'Home working schedule', Employee.Email = User().Email ) }, If( IsBlank(wMail.ID), NewForm(EditForm1_1), Patch( 'Home working schedule', {ID:wMail.ID}, {OUT_OF_OFFICE:{Value:"Yes"}} ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
GGG666 180 on at

Like (0)

Report
Copy link

Link copied!

Hi WarrenBelz,

Now i change the column to Text type.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,930 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@GGG666 ,

We are going in circles - you have now broken your toggle. Please put it back to what it was in your original post - Yes/No (Boolean) and the solution is in the second-last post of mine.

Was this reply helpful? Yes No