Answered

undefined

(0) Share

Report

Posted on by Amarreddye89

How can i write power app function like (Approved Status column is Blank & A_Status = new) or (Approved Status column is Approved & A_Status is Blank )

Thanks for Advance.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

If(IsBlank(ApprovedStatus) And A_Status = "new", [true result], [false result])
Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Amarreddye89 ,

Considering both are text fields then your formula will be:

If( ( IsBlank('Approved Column') && A_Status = "new") || ( IsBlank(A_Status.Text) && 'Approved Column' = "Approved"), //true, //false )

If its option set/choice field then access its value following with '.' (Dot operator)

Hope this helps
Amarreddye89 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for Quick reply Sir..
My Actual formula adding in filter also..so not able to combined both formulas..
FILTER (
FILTER ( SharePoint list table name,
Title = Drop-down.SelectedText.Value
),
Or
If(
( IsBlank('Approved Column') && A_Status = "new")
||
( IsBlank(A_Status.Text) && 'Approved Column' = "Approved"),
//true,
//false
)

Kindly help me out about this formula Sir .
Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Amarreddye89 ,

I'm not sure what you are doing in formula, but as per this here are 2 possible filters that I see,
//Considering Either Title or Status filter Filter( 'SharePoint list table name', Title = Dropdown.SelectedText.Value || ( (IsBlank('Approved Column') && A_Status = "new") || (IsBlank(A_Status.Text) && 'Approved Column' = "Approved") ) ) //Considering Both Title and Status filter Filter( 'SharePoint list table name', Title = Dropdown.SelectedText.Value && ( (IsBlank('Approved Column') && A_Status = "new") || (IsBlank(A_Status.Text) && 'Approved Column' = "Approved") ) )

Hope this helps in your scenario
Amarreddye89 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sir,

I am trying to display the records using share point list table for below conditions need to be added
1. Approval status is Blank and A-Status=New
2. A_Status is Blank and Approval Status = Approved.

I hope now you have understood my requirement.
Many Thanks,
Amar
Verified answer

Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Amarreddye89 ,

You can use the formula given by me on the top:
Just simply use Option set values like
//For A-Status if its Choice datatype A-Status.Value = "New" //For Approval Status if its Choice datatype 'Approval Status' = Choices('Approval Status (SP Name)'.Approved) //OR 'Approval Status'.Value = "Approved"

Do check out the syntax based on your App intelisense as I'm not sure of the name
Hope this helps
Amarreddye89 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay..Thank you so much For kind answers..will check and get back to you sir.