Answered

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)

Kuno66 71 on at

Like (0)

Report
Copy link

Link copied!

ok. open a new thread...

https://powerusers.microsoft.com/t5/Building-Flows/calculated-date-field-shows-wrong-time-if-hidden-on-new-entry/m-p/1108881#M137121

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,402 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Kuno66,

I am happy to help. However, can you post this new question in a separate thread?

This way we can separate the questions and solutions from each other. This also makes it a bit more reusable for the rest of the community 😀

Was this reply helpful? Yes No
Kuno66 71 on at

Like (0)

Report
Copy link

Link copied!

Hi..it´s me again...
I have another question about a problem that has been dragging on for a long time.
I use the hide field formulas on the new entry form to hide fields, that user doesn´t need to see.
Everything work as expected just a date/time filed. "ErstellDat..gives me problems.
If i use as default value Todays date everything works fine, but i can´t hide the field.
If i use the calculated value Now() i can hide the field but it gives me a complete wrong date and time.
I already checked the regional settings of client and sharepoint online. everything is on Central European...
What is wrong?
wrong date

Was this reply helpful? Yes No
Verified answer

kuno6661 13 on at

Like (1)

Report
Copy link

Link copied!

thank you very much for your help.
regards
kuno

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

Like (0)

Report
Copy link

Link copied!
@Kuno66, you can amend the expression to use nested if functions. But the expression becomes a bit longer:

if(equals(outputs('Get_item')?['body/Ansuchen/Value'], 'Weiterbilding'), 'test@test.com', if(equals(outputs('Get_item')?['body/Ansuchen/Value'], 'Aussendienst'), 'aussendienst@test.com', if(equals(outputs('Get_item')?['body/Ansuchen/Value'], 'Abrechnung Aussendienst'), 'abrechnung@test.com', 'andere@test.com')))

Or another approach would be to use a mapping array and filter that array based on that Ansuchen Value. I would suggest that approach when the amount of choices is a bit more.

Was this reply helpful? Yes No
Kuno66 71 on at

Like (1)

Report
Copy link

Link copied!

now it works.:-<))
what if the 3 other choices map 3 differnet email address?

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

Like (0)

Report
Copy link

Link copied!
Hi @Kuno66,

In that case you could just use the false part of the if function for those other three choices. Below is an example.

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

Was this reply helpful? Yes No
Kuno66 71 on at

Like (0)

Report
Copy link

Link copied!

i have 4 choices "Aussendienst" - Weiterbildung - Abrechnung Aussendienst - Andere
the other 3 choices can mapped to the same email adress.

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

Like (0)

Report
Copy link

Link copied!

Hi @Kuno66,

That is correct, the sample only works with the Weiterbildung choice. If you want it to work with other choices as well you need to amend the expression to meet that requirement.

Which other options do you have? And do they need to be mapped to the same e-mail address or to a different e-mail per choice option?

Was this reply helpful? Yes No
Kuno66 71 on at

Like (0)

Report
Copy link

Link copied!

i added a get item action and used the expression. now it workes but the flow fails with applying the grant access items. when i use the choice weiterbildung everything works fine, when i user some of the other coices flow fails and grant access rights are not apllied.
The 'inputs.parameters' of workflow operation 'Grant_access_to_an_item_or_a_folder' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'parameter/recipients' is required to be of type 'String/email'. The runtime value '"kuno66@test.com;admincloud@test.onmicrosoft.com;Sharepoint-Genehmiger@test.com;Sharepoint-Finanzdienst@test.com;Sharepoint-Personalamt@test.com;;Do nothing"' to be converted doesn't have the expected format 'string/email'.

Was this reply helpful? Yes No