Answered

Nav button fomula

(0) Share

Report

Posted on by Ziggy-80

Hey Guys 'n Galz,

Im sitting here pulling out my hair as I dont quite know the correct formula command to use for my second check. Please can you assist me in findng a solution.

I've created an app which relies on two CDS entities (Pulse Check Questions & Pulse Check Responses). I would like my next button to perform two checks before proceeding to one of two pages available. Check 1 is to ensure all the necessary responses have been captured. Check 2 is to check the CDS entity (Pulse Check Responses) to see if the user has previously captured data, thus directing them to the KPI Update screen, if the user has never captured data I would like to direct them to the KPI Input screen instead. Below please find my formula thus far.

If(Or(PC_Dropdown1.Selected.Value="Blank",PC_Dropdown2.Selected.Value="Blank",PC_Dropdown3.Selected.Value="Blank",PC_Dropdown4.Selected.Value="Blank",PC_Dropdown5.Selected.Value="Blank",PC_Dropdown6.Selected.Value="Blank",PC_Dropdown7.Selected.Value="Blank",PC_Dropdown8.Selected.Value="Blank",PC_Dropdown9.Selected.Value="Blank",PC_Dropdown10.Selected.Value="Blank",PC_Dropdown11.Selected.Value="Blank",PC_Dropdown12.Selected.Value="Blank",PC_Dropdown13.Selected.Value="Blank",PC_Dropdown14.Selected.Value="Blank",PC_Dropdown15.Selected.Value="Blank"),UpdateContext({PC_Error1:true}),If(LookUp('Pulse Check Survey Responses',Username=User().FullName,'Pulse Check Survey Responses'),Navigate('KPI Update',ScreenTransition.Fade),Navigate('KPI Input',ScreenTransition.Fade)

Regards

Ziggy-80

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Ziggy-80 11 on at

Like
a
(0)

Report
Copy link

Link copied!

In Addition, I seems to be stuck at the "Search / LookUp / Find / Filter" stage of the check.

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ziggy-80,

So the issue here should be related with the following part?

If( LookUp('Pulse Check Survey Responses', Username=User().FullName, 'Pulse Check Survey Responses'), Navigate('KPI Update',ScreenTransition.Fade), Navigate('KPI Input',ScreenTransition.Fade) )

The first parameter of function if() expects a Boolean value, while none of the filter, search or lookup would return value in the boolean format.

If you would like to check whether the entity contains data of current user, then we could write the formula below to check:

If( IsEmpty( filter('Pulse Check Survey Responses', Username=User().FullName ) ), Navigate('KPI Input',ScreenTransition.Fade), Navigate('KPI Update',ScreenTransition.Fade) )

Filter() function here would return a table contains the entity record which username equals current user name, IsEmpty() is used to check if the table returned is empty, if yes, KPI Input, if not empty, KPI update.

Check to see if this would work for you.

Adding the function reference:

Filter, Search, and LookUp functions in PowerApps

Blank, IsBlank, and IsEmpty functions in PowerApps

Regards,

Michael

Was this reply helpful? Yes No
Verified answer

Ziggy-80 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Michael,

After much stress I finally figured it out and got it to work as I would like. I ended up with the following code:

If(Or(PC_Dropdown1.Selected.Value="Blank",PC_Dropdown2.Selected.Value="Blank",PC_Dropdown3.Selected.Value="Blank",PC_Dropdown4.Selected.Value="Blank",PC_Dropdown5.Selected.Value="Blank",PC_Dropdown6.Selected.Value="Blank",PC_Dropdown7.Selected.Value="Blank",PC_Dropdown8.Selected.Value="Blank",PC_Dropdown9.Selected.Value="Blank",PC_Dropdown10.Selected.Value="Blank",PC_Dropdown11.Selected.Value="Blank",PC_Dropdown12.Selected.Value="Blank",PC_Dropdown13.Selected.Value="Blank",PC_Dropdown14.Selected.Value="Blank",PC_Dropdown15.Selected.Value="Blank"),UpdateContext({PC_Error1:true}),If(!IsBlank(Last(LookUp('Pulse Check Survey Responses',Username=IN_User,'Pulse Check Survey Responses'))),Navigate('KPI Update',ScreenTransition.Fade),Navigate('KPI Input',ScreenTransition.Fade)))

Best Regards
Hugh

Was this reply helpful? Yes No