Help needed with formula for counting entries in Power App collection

(0) Share

Report

Posted on by DJanssen

427

Hello,

I need some help to revise my formula currently present on my Default property of a text value:

If(!IsBlank(FunctionCodeDropdown.Selected) && !IsBlank(DocumentTypeCodeDropdown.Selected) || varTriggerCalculation, Text(Value(CountIf(DocumentNumberCollection, DocCode = CurrentDocCode.Text && HasAttachment = false)+1) + 0, "00"))

What I want to achieve is that it counts the first entry. I thought that I could achieve this by adding the && HasAttachment = false and get Doc Reference: ENOWA-WA-WMG-POL-02 in return. But when I test this functionality in my app it remains as: 01 (meaning 0 entries are found possibly)

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

DJanssen 427 on at

Like
a
(0)

Report
Copy link

Link copied!

Published it and tested it out on the app itself. It seems to work on publish. Not sure why it didn't work in my Power App editing form itself but it has been solved!