Answered

Use Lookup In EditForm: Network Error when using Patch function. Record not found.

(1) Share

Report

Posted on by Xeon0021

116

Hey guys,

I ve tried a lot over many hours and I am not getting what exactly I am doing wrong. Hopefully someone of you have a solution.

I have two sql tables one table where I have articles with data like article_ID, Title, manufacturer, types.Type_ID and so on.

The second table has types in it such as notebook, tablet etc. data: Type_ID, Title, icon

I use an edit form where people can create new articles and also shall put in the type via an dropdown or an combobox but I am not able to Connect the two tables.

My Dropdown Item Funktion mention the type table with the title as Value

The Update function is a LookUp(TypeTable,DataCardValue49.Selected.Title = Title, Type_ID)

Any help is much appreciated.

With best regards Leon

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Shaheer Ahmad 2,194 Moderator on at

Like (1)

Report
Copy link

Link copied!
Here are a few things to check and consider:
Network connectivity: Verify that you have a stable network connection. Network errors can occur if there are connectivity issues between Power Apps and your SQL database. Ensure that you have a reliable and consistent network connection to prevent network errors.
SQL database connection: Double-check your SQL database connection in Power Apps. Ensure that the connection is properly established and authenticated. If the connection is not set up correctly, it can lead to network errors or difficulties retrieving data from the SQL tables.
DataCardValue49.Selected.Title: Confirm that the DataCardValue49 represents the control (dropdown or combobox) where you're selecting the type. Check if the Selected property is correctly referring to the dropdown or combobox control and that it contains the expected value. You can use the UpdateContext function to store the selected value in a variable for better readability and debugging.
Lookup function syntax: Review the syntax of the Lookup function. The first argument should be the name of the table or data source you want to search in, followed by the condition to match against. In your case, it seems like the condition is DataCardValue49.Selected.Title = Title. However, ensure that Title corresponds to the correct column name in your TypeTable.
Patch function: Ensure that the Patch function is properly configured to update the article record with the selected type. Verify that you're using the correct table and columns in the Patch function to update the article's type based on the Lookup result.

If this does not help. Kindly share screenshots of the formula. And please add your lookup formula to a testing gallery and see if it returns a row.

Was this reply helpful? Yes No
Verified answer

Xeon0021 116 on at

Like (0)

Report
Copy link

Link copied!

Oh I found the solution, it is much simpler than I thought. Here is my Solution:
In The Update Property u must do a:
DataCardValue49.SelectedText.TypID
No lookup needed.

Was this reply helpful? Yes No