Hello everyone,
I have a canvas app connected to an Excel file with this formula in a TextInput as its Default value:
If(IsBlank(Last(Filter(Table,Column1 = condition).Column2)),Blank(),Last(Filter(Table,Column1 = condition).Column2))
So if the cell referred by the formula is empty, a blank value is supposed to be returned. But instead, a 0 appears. I made sure there was nothing contained in the cell pointed but it keeps showing me a 0 instead of the blank value I need.
I have tried using this formula instead:
If(Last(Filter(Table,Column1 = condition).Column2)=0,Blank(),Last(Filter(Table,Column1 = condition).Column2))
But the problem with this formula is that if there´s an actual 0 contained in the cell, the app will display a blank vlaue.
Please help me!
Solved! Go to Solution.
Hi @Anonymous ,
Yes, that would be the outcome and probably a reason to read this article.
You might consider acquainting yourself with a SharePoint backend.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
This could be an Excel issue because of the way that Excel evaluates blank cells. See this article from Microsoft: https://docs.microsoft.com/en-us/office/troubleshoot/excel/use-formula-evaluate-blank-cell. Try editing your spreadsheet so that the cells aren't simply blank. Then edit your PowerApps statement to reflect your change in Excel.
Hi @Anonymous ,
Try this
With(
{
vCondition,
Last(
Filter(
Table,
Column1 = condition
).Column2
)
},
If(
IsBlank(vCondition) || vCondition=0
Blank(),
vCondition
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @WarrenBelz ,
Thanks for your reply!
I´m afraid this won´t work in my case. I need a 0 value returned when there´s an actual 0 in the cell. The code you described returns Blank in any of both cases. Please tell me if I´m mistaken.
I also tried leaving only the IsBlank(vCondition) statement but it wasn´t useful.
Hi, I think if you work the problem in Excel, you'll have a better outcome in PowerApps.
In Excel if you make a column that evaluates your cells for blank qualities like this:
=IF(ISBLANK(A1),"Blank",A1)
I think you will get the results you want downstream in PowerApps.
Hi @Anonymous ,
Yes, that would be the outcome and probably a reason to read this article.
You might consider acquainting yourself with a SharePoint backend.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @Anonymous ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @WarrenBelz ,
Thanks for the useful tip. From now on I will use Sharepoint lists for all of my new proyects.
So just to be clear, there is now way my problem can be solved with Excel as back end? It would take me a lot of work to move my actual data source entirely to Sharepoint!
HI @Anonymous ,
I am not an Excel user, but I do a bit of work on this forum and have seen numerous issues with Excel that simply do not happen with SharePoint. There is no code to solve things that should work an do not and even if you solved this one, I am fairly confident you will be back with another roadblock before too long if you want any scalability with Excel - it is a spreadsheet, not a database.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
190 | |
53 | |
51 | |
35 | |
33 |
User | Count |
---|---|
268 | |
92 | |
80 | |
68 | |
67 |