Deeplinking not working for lookup column

(0) Share

Report

Posted on by Poweruser32490

I have a powerapps form where i am deep linking it based on lookup column value. Somehow it doesn't work and throws error Getting your Data as per below screenshot.

Deeplink Form Item Property

If(
    Not(IsBlank(Param("ResponseID"))),
    LookUp(
        'Responses',
        'Response ID'.Value = (Param("ResponseID")) && Account.Id = Value(Param("AcountID")) && Branch.Id = Value(Param("BranchID"))
    ),
    LookUp(
        'Responses',
        'Response ID'.Value = Text(responseitem.'Item ID') && Account.Value = Account&& Branch.Value = Branch
    )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

whitebeard 135 on at

Like (0)

Report
Copy link

Link copied!

Hi @Poweruser32490,

The "Getting your data" freeze typically happens when there is a type mismatch in the query that causes a runtime error.

In your Item property formula, you are wrapping the Account and Branch parameters in Value(). Since Dataverse/Dynamics IDs are GUIDs (alphanumeric strings), Value() will fail because it tries to convert them into a number.

You should use GUID() instead. Also, there is a small typo in your parameter name (AcountID vs AccountID).

Try this corrected formula:

If(
!IsBlank(Param("ResponseID")),
LookUp(
'Responses',
'Response ID'.Value = Value(Param("ResponseID")) &&
Account = GUID(Param("AccountID")) &&
Branch = GUID(Param("BranchID"))
),
LookUp(
'Responses',
'Response ID'.Value = Text(responseitem.'Item ID') &&
Account = Account &&
Branch = Branch
)
)

Hope this helps!

Was this reply helpful? Yes No
Suggested answer

Kalathiya 1,804 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @Poweruser32490,

The “Getting your data” message appears when no record is found for the filter conditions used in the Item property.

This usually happened:

The combination of parameters passed in the deep link does not match any existing record

One or more lookup values (ResponseID / Account / Branch) are incorrect or missing

Data types don’t match (text vs number / lookup)

Please verify below points:

The record actually exists in the Responses table and all query parameters are passed correctly.

Lookup fields are compared using the correct column.

If the filter returns no record, the form will stay in “Getting your data” state.

Note: If the issue is still not resolved, could you please share a sample data list screenshot and the deep link query URL you are using?
This will help us verify whether the record exists and check the filter condition.

📩 Need more help? Mention@Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping.

Was this reply helpful? Yes No