Answered

Getting error in form navigation conditional navigation

(0) Share

Report

Posted on by Veblitz

2,249

In my sourcing navigation in the left,im unable to see the approvers name beneath 1.1 sourcing as im getting below error details are unable to retrieve data but im able to see 1 Requestor John approver name

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Suggested answer

Mark Nanneman 993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Just a guess bc I don't know your datasources and structure, but my gut instinct is the issue is with your concat structure. I'm guessing "DisplayName" is a property of an array contained in ".AssigenedOwners" in NewItemSetupOwners.

You need to write your concat like: Concat(LookUp(NewItemSetupOwners,(Department=ThisItem.Name)).AssignedOwners,DisplayName&"; ")

The Concat should only have two parameters, the array and the expression, and if you want a ";" after each item you'd put a &"; " after it.
In your screenshot, it looks to me like you have three parameters (two commas) in your Concat() formala.

Concat(<assignedOwners>,DisplayName,";")

So try replacing that last comma with an "&". If that doesn't work, can you show the error message that appears when you hover over the red underlined formula in your screenshot?

I would also recommend standardizing your text formatting method, it might look cleaner (and be easier to write) if you put as much as possible in an $-String.

Matthew Devaney has an article on the $-string:
https://www.matthewdevaney.com/strings-a-better-way-to-concatenate-text-strings-in-power-apps/#$-String-Usage-Examples

And maybe I'm missing something, but it looks like you repeat the same exact Concat formula for both your true and false condition on the last If(), which makes that If() unnecessary.

It also might help if you use a With() function to store commonly referenced values as inline variables--saves writing time and makes your code easier to read.

Something like:
ronaldwalcott 3,914 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Show the error message.

Not sure why you have the parentheses around Department=ThisItem.Name.

You can try adding AssignedOwners into the LookUp as LookUp(NewItemSetupOwners, Department=ThisItemName, AssignedOwners) which I am assuming returns a table of assigned owners.
Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Veblitz

Adding a bit different input here - the last two arguments are the same result, so why bother with the test. Also you please remember to post your code in Text - saves re-typing here - the code below is OCR'd so watch spelling. Assuming that AssignedOwners is a multi-value Person column in NewItemSetupOwners -
If( ThisItem.Name = "Requester", "Requester", "Approver(s):" ) & Char(10) & If( ThisItem.Name = "Requester", User().FullName, Concat( LookUp( NewItemSetupOwners, Department = ThisItem.Name ).AssignedOwners, DisplayName, "; " ) ) )

Also note that both Concat( . . . .).DisplayName,"; ") and Concat( . . . .).DisplayName & "; ") are valid except second one adds an extra delimiter on the end (email1; email2; email3; ) instead if (email1; email2; email3 )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee