Answered

Last stage but stuck - How to Respond to A Power App or flow

(0) Share

Report

Posted on by janiceXcruz

Kamusta? I got the output from this flow, but I do not know how to finish it in Responding to a Power App. Sorry if this is a bother, trying my best to learn here. Salamat.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Tomac 3,966 Moderator on at

Like (0)

Report
You can't select array properties by letter, they're indexed by number. Instead of

body('Compose')?['d']?['ItemCount']

Try this:

body('Compose')?['3']?['ItemCount']

It'll be item 3 instead of 4 (d is the 4th letter of the alphabet, not the third) because array indexes start counting at item 0, not at item 1.

Was this reply helpful? Yes No
janiceXcruz 74 on at

Like (0)

Report

Hello again sir @Tomac. I just want a result to get the count of rows of value "Issuance" in the "TransactionType" column. The result is blank when I tried the flow below.

Was this reply helpful? Yes No
Verified answer

Power Platform 1919 1,898 on at

Like (0)

Report

Hi @janiceXcruz,
Your compose action is wrong, it should be power automate expression, instead it was plain text string, which is causing this issue
Sample pic:

this should resolve the issue.
Please let me know if you need help

Was this reply helpful? Yes No
janiceXcruz 74 on at

Like (0)

Report

Hi @Power Apps 1919. It resulted an error,

Was this reply helpful? Yes No
Power Platform 1919 1,898 on at

Like (0)

Report

HI @janiceXcruz, as the error message stated, either referenced column is wrong or deleted, just to be sure, check the column in SharePoint sometimes (internal names and displaynames are not same).
that could cause an issue,
with out seeing actual list, i can speculate it is column name missmatch

Was this reply helpful? Yes No
janiceXcruz 74 on at

Like (0)

Report

Oh my. I got it. I got it. Thank you @Power Apps 1919. You're a genius I also have to checked the original Field Name of that "TransactionType" column. It worked!

Was this reply helpful? Yes No
Power Platform 1919 1,898 on at

Like (0)

Report

Hi @janiceXcruz,
Sample PIC attached :

Here Department is field_3 , and Name is field_1.
And as for, why this happens,
the list is created using excel/csv import (the displaynames will match , but internal names will not).
if you use normal list which was created in UI, mostly names would match.
Sample PIC 2 :(list created manually):

Please let me know if need help.
If this solved the issue, Please close the thread !!!

Was this reply helpful? Yes No