Answered

Correction of If Formula for Table Records

(0) Share

Report

Posted on by MIA27

I have a table view record with connected to Sharepoint List. Its working fine, But when I try to add some more design to alert to user by using IF with emogy, then no result no error

sharepoint list and data type to explain better :

Applied IF() on Date Field , not working,

Applied IF() on Numeric field, still not working :

My canvas view with error result

Could not understand the reason of error.

Kindly guide

Also tried the below at last - still not work

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (3)

WarrenBelz 154,496 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @MIA27 ,

Two things - why are you using text conversions on SharePoint date fields (they should just compare on their own), but most importantly, Data Tables are generally not able to accept design elements like galleries are (what character are you using to get those red and blue circles ?)

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,577 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @MIA27 ,

I got both to work:

Date:

As @WarrenBelz mentioned, the text conversion in the condition caused the issue.

Number:

In you formula there was a brace to many at the end.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

Sir,
Text conversion is required as the date displayed in sharepoint and in powerapp is in the format 3/31/2023 12:00 AM (mm-dd-yyyy)
While users requirement is to show in dd-mm-yyyy , I mean like this 31/03/2023.
As you and Mr. Buizer guided, in comparison I removed the format and it worked, and later i applied the format in the display and it worked
If(ThisItem.BdEndDate < Today(),"🔴","🟢") & " "
& Text(ThisItem.BdEndDate,"dd-mm-yyyy")

As the table does not accept design element, therefore I tried to implement an idea of adding a sign showing the user that Red circle it is expired and green it is still not. Its emogy - keeping the cursor at the required place, to press Window key + . , it opens up the emogy list and it can be selected from there. Also noted that it is accepted in all places even in App Naming also.

I need your advise on the below 2 requirement :
a) Now the user wants the yellow indication if the expiry is coming within 10 days, so that they can start preparation. Need to add another If within If . I am stuck here.

b) The comparison I did was based on date and Number. But if the situation will be based on Text then = operator will work.

Please guide in the above 2 requirement, for my knowledge and further implementation in work.

Thank you,

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

Sir,
Thank you both worked. date worked after removing the format and number worked after removing the last bracket,

A bit stuck for few more query, posted in the Mr. Warren reply, Could be helpful if you can also have a look and guide some idea on it.

regards

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,496 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@MIA27 ,

Firstly @BCBuizer has solved the first part - I am actually surprised your Data Table accepted the non-standard character (although I do not use either). As for the dates, the format is actually stored in SharePoint in UTC and converted by your Regional Settings, so you can use the actual date for the comparison and the Text conversion for the display (as you have now) OR simply fix your Regional Settings on the SharePoint site and / or your local devices.

If( ThisItem.BdEndDate < Today(), "🔴", ThisItem.BdEndDate <= Today() + 10, "🟡", "🟢" ) & " " & Text(ThisItem.BdEndDate, "dd-mm-yyyy")

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!
Sir,
Thank you, had to add another IF in-between and it worked, all the 3 colors.

Was expecting your advise on my second parts of requested question
b) The comparison I did was based on date and Number. But if the situation will be based on Text then = operator will work.

For example Like for any Field Text is Expired, can I put the criteria
ThisItem.ValidityStatus = "Expired"
or it should be in 'Expired' in single quote.

This home work will help me to cover all major 3 types of criteria for my learning and utilization.

Regards

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,496 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@MIA27 ,

You do not need the second If() (as per what I posted).- although it will also work with it. "Expired" needs to be in double quotes if it refers to the Text value.

Was this reply helpful? Yes No