Unanswered

Hiding formula with two different values

(0) Share

Report

Posted on by Kuno66

i have a hiding formula on the new entry form--=if([$StatusAnsuchen]=='Pending','false', 'true') that works fine so far. but now i´d like to add another statement based on other columns value (choice column)--=if([$Ansuchen]=='Andere','true', 'false') how can i add them together? i tried ...=if([$StatusAnsuchen]=='Pending','false', 'true' && [$Ansuchen]=='Andere','true', 'true')) but its not working...

thanks for any help

kurt

Categories:

Using flows

I have the same question (0)

All responses (22)

Answers (2)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @Kuno66,

You are talking about a conditional formula for a field in a SharePoint view, correct? This is not directly related to Power Automate but I will try and help you out anyway 😁

Can you try and use this formula instead?

=if([$StatusAnsuchen] == 'Pending' && [$Ansuchen] == 'Andere', 'false', 'true')

More examples can be found over here:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide#get-started-with-conditional-formulas

Was this reply helpful? Yes No
Kuno66 71 on at

Like (0)

Report

hello...
its me again...
it is possible with a formula to write value based on a choice field?ex.

=if([$Ansuchen]=='Weiterbildung', write value to field 'true', 'false')

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Kuno66,

That depends. Does your choice column allow the selection of multiple values?

That type is not supported:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide#unsupported-column-types-in-conditional-formulas

A choice with a single value should work. In that same document they also have an example for that:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide#choice-column

Was this reply helpful? Yes No
Kuno66 71 on at

Like (0)

Report

no selection multiple values.
but how do i compose the formula?
=if([$Ansuchen]=='Weiterbildung', write value to field 'true', 'false')...
the formula reference only if choice field and column have a certain value. ok that works.
but i need if choice is weiterbildung than add email address to field.

thank you

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Kuno66,

These example are only to show or hide fields, formulas for form configuation. I think you are now talking about different formulas, it sounds like you are now talking about calculated columns?

Was this reply helpful? Yes No
Kuno66 71 on at

Like (0)

Report

yes if i can reach my goal.
but i can´t find the right formula.
i have that text column called "Weiter". and a choice column mit choices.
can i add a calculated value in the column Weiter that looks at the choice column? ex.
if choice column is sharepoint than add value blablabla....

Was this reply helpful? Yes No
Kuno66 71 on at

Like (0)

Report

maybe i can achive this in flow?
but what is the formula there.? if ansuchen value= weiter than add test@test.com else use value.
or better in the grant access to an item section because i need it there

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @Kuno66,

You could use an expression like below in the update item.

You might need to update the expression a bit. I am using a Get Item action.

if(equals(outputs('Get_item')?['body/Ansuchen/Value'], 'Weiterbilding'), 'test@test.com', 'Do nothing')

Was this reply helpful? Yes No
Kuno66 71 on at

Like (0)

Report

saving the flow gives me an error:
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The action(s) 'Get_item' referenced by 'inputs' in action 'Update_item_2' are not defined in the template.'.'.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Kuno66,

What is the name of the action you are using to collect the value of Ansuchen? In my case it is called Get Item. That might not be the case in your flow.

Was this reply helpful? Yes No