web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to use Excel Data ...

Power Apps

Answered

How to use Excel Data for an IF function

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello.

I have a quick question regarding Excel Sheets connected to a PowerApp via OneDrive.

I want to make an IF function which would check if a current Excel Entry has a certain value or not.

However I do not know how to write this IF statement. I am unsure how to make PowerApps check for the required data.

ThisItem.ExcelData does not seem to work, as it's only function is to set whatever it's put on to the given value.

This is what I have right now, but as I mentioned, it doesn't work.

If(ThisItem.ExcelData="Value",true,false)

Any help would be greatly appreciated.

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous
Are you trying to check a row in your Excel table to see if a value exists?

If yes, does your table have and column that stores a unique ID? How can we identify which rows needs to be checked?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I am currently within editing an existing form, so usually the correct row of data is already selected (based on the ID PowerApps gives that certain data row, I suppose).
So all I need to know is how to make PowerApps ask if a specific value is set to something.
Verified answer

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous
You definitely have the right technique:

=If(ThisItem.YourColumnName, true_condition, false_condition)

Did you make a recent change to the sheet? Have you tried refreshing the datasource using the left-side menu?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It seems like my method actually works.
I am running into another problem them, unrelated to the topic at hand.
I will create another topic for it, should I still not be able to get results by myself any time soon.

Thank you for you support!

Join the conversation