Unanswered

If funktion and multi funktion

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi every one,

I'm having some big trouble getting my formula working.
Hope you can help.
Would like that if "Regnskabskunde" or "Regnskabs- og Plantekunde" is selected and if the 3 fields that you can see in the picture are ø90 number, chart of accounts number and industry code are empty, a red triangle must be displayed I have tried a formula that looks like this, but it does not work optimally as it does not take into account the 2 other options you can choose.

Hope you can help 🙂

-PHH

Categories:

Building Power Apps

All responses (13)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

If(And(Or(DataCardValue74.Selected.Value = "Regnskabs- og Plantekunde",DataCardValue74.Selected.Value = "Regnskabskunde"), Or(IsBlank(ThisItem.'90-nr.'),IsBlank(ThisItem.'Kontoplan nr.'),IsBlank(ThisItem.Branchekode))),true,false)

Please fix the field names as I have missed a few symbols in the column names.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255

I have tried now but it does not work.

If(And(Or(DataCardValue74.Selected.Value="Regnskabs- og Plantekunde",DataCardValue74.Selected.Value= "Regnskabskunde"),Or(IsBlank(ThisItem.'Ø90-nr.'),IsBlank(ThisItem.'Kontoplan nr.'),IsBlank(ThisItem.Branchekode))),true,false)
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

The expression looks okay to me. Can you please verify if the spelling in the text values is correct?

Can you do a test and share the results with me?

Add four test labels on your screen and add the text value as:

Label1 -> Or(DataCardValue74.Selected.Value="Regnskabs- og Plantekunde",DataCardValue74.Selected.Value= "Regnskabskunde")

Label 2 ->IsBlank(ThisItem.'Ø90-nr.')

Label 3 -> IsBlank(ThisItem.'Kontoplan nr.')

Label4 -> IsBlank(ThisItem.Branchekode)

Please share a screenshot of the results so that we may help you better.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255,
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Looks like there is some issue with the radio button selection. Can you please verify if the spellings are correct for the text that you want to match?
Second, can you please replace the text property of label 1 to DataCardValue74.Selected.Value and check if it is returning the proper value?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255,

I'm just trying some different things. When is it possible to write with you tomorrow?
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

I will be around so whenever you get a moment please reply on the same thread.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255 ,
A

s you can see in the picture it says "Quick Create" by all the fields all the way down. But when I go into some of them it may not be "Quick Create" Do you have an explanation for that?

the field where it says 2 from has been selected "Regnskabskunde" behind
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

To understand it better, can you please share the screenshot of the configuration from where you are getting the radio button selection. I am guessing the catch is related to that value. Please share more details, so that we might be able to help you better.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255

Can you use this?

- Peter