cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nithishguptak
Helper I
Helper I

Value based on a field

Hello all,

 

If(!IsBlank(DataCardValue45_1 & DataCardValue7_1.Selected.Value & DataCardValue47_1.Selected.Value); "Ursache identifiziert"; "Erfasst" ;

!IsBlank(DataCardValue44_1); "bewertet";)
!IsBlank(DataCardValue49_1); "Abstell maßnahme definert")

 

So I have been trying to implement the above code. In my case I check if DataCardValue45_1 & DataCardValue7_1.Selected.Value & DataCardValue47_1.Selected.Value are empty fields, if they are not empty fields then It is Ursache identifiziert if not Erfasst. Till here it works fine, but problem is after Ursache identifiziert and Erfasst condition is fullfilled I have to check if DataCardValue44_1 is not empty then there should be a message saying bewertet and again same with DataCardValue49_1 if its not empty then message is Abstell maßnahme definert.

 

can you someone enlighten me how does multiple if statments work in powerapps ? 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

If(!IsBlank(DataCardValue45_1.Text) && !IsBlank(DataCardValue7_1.Selected.Value) && !IsBlank(DataCardValue47_1.Selected.Value);

   "Ursache identifiziert"; 

     If(!IsBlank(DataCardValue44_1.Text);

         "Schaden bewertet";
          If(!IsBlank(DataCardValue2_1.Text);

          "Abstell";

          "Erfasst"

           )

       )

)

 

So, if they are all filled, it will write: "Ursache identifiziert". If not and if DataCardValue44_1 is filled, it will write: "Schaden bewertet". If not and if DataCardValue2_1, it will write: "Abstell". If not, it will write: "Erfasst"

 

Also, it was missing ".Text" after DataCardValue2_1 and DataCardValue44_1

View solution in original post

4 REPLIES 4
Nogueira1306
Super User
Super User

To make an AND confition

 

If( Value = 1 && Value2 = 2,

....

 

OR

 

If( Value = 1 and Value2 = 2,

....

 

To make Or condition:

 

If( Value = 1 ORValue2 = 2,

....

 

OR

 

If( Value = 1 || Value2 = 2,

....

 

 

https://docs.microsoft.com/EN-US/power-apps/maker/canvas-apps/functions/function-logicals

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

I changed accordingly but still I dont get the required value 

 

If(!IsBlank(DataCardValue45_1 & DataCardValue7_1.Selected.Value & DataCardValue47_1.Selected.Value); "Ursache identifiziert"; "Erfasst";
If(!IsBlank(DataCardValue44_1); "Schaden bewertet");
If(!IsBlank(DataCardValue2_1); "Abstell"))

If(!IsBlank(DataCardValue45_1.Text) && !IsBlank(DataCardValue7_1.Selected.Value) && !IsBlank(DataCardValue47_1.Selected.Value);

   "Ursache identifiziert"; 

     If(!IsBlank(DataCardValue44_1.Text);

         "Schaden bewertet";
          If(!IsBlank(DataCardValue2_1.Text);

          "Abstell";

          "Erfasst"

           )

       )

)

 

So, if they are all filled, it will write: "Ursache identifiziert". If not and if DataCardValue44_1 is filled, it will write: "Schaden bewertet". If not and if DataCardValue2_1, it will write: "Abstell". If not, it will write: "Erfasst"

 

Also, it was missing ".Text" after DataCardValue2_1 and DataCardValue44_1

nithishguptak
Helper I
Helper I

@Nogueira1306 such a saviour you are ! Thanks its working like how I wanted 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,357)