Retrieve ProjectId from ProjectName

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have the following:

When I press Add my Project table gets patched and the an Id is automatically assigned by the SQL server.

That works smoothly.

Now I want to collect the Id of the project into a variable so:
As the last 2 lines in the Add button I have the following:

ClearCollect(Projects,'[PowerApp].[ProjectBoard]'.Id, '[PowerApp].[ProjectBoard]'.ProjectName);
Set(varProjectID, Filter(Projects.Id, Projects.ProjectName = TextInput3.Text));

But the last line fails with this error:

Incompatible type. We can't evaluate your formula because the context variable types are incompatible with types of vaules used in other places in your app.

Does anybody know why?
Or is there another way of getting the Id?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

The reason for this error is because the filter function returns a table, and I suspect that varProjectID is a variable that you've used to store an integer value in other places in your app.

Rather than make a call to look up the project record that you added by project name, the correct way to do this is to retrieve the return value from patch. This will give you the ID of the record that was created.

Here's an example of the syntax you would use.

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-get-created-record-id-from-patch-function/m-p/263771

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, but...how do I get that single Id value into a variable?
Can I use Set(VarName, CollectionName) ?
Won't the variable be angry and say that you are trying to put a table into a variable?

Was this reply helpful? Yes No
Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

I don't understand what exactly you want to do here. It isn't necessary to collect the project details into a collection. If you want to collect only the ID and projectname columns of all rows into a collection, this is the syntax that you use.

ClearCollect(Projects, ShowColumns('[PowerApp].[ProjectBoard]', "Id","ProjectName"))

You would then use the following formula to retrieve the ID of the record by project name.

Set(varProjectID, LookUp(Projects, ProjectName = TextInput3.Text).Id)

I recommend that you directly retrieve the ID from the return value from patch as I mentioned earlier.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

All I want is to get the Id from the created record into a variable.
This formula works for me:
Set(
varProjectID,
LookUp(
'[PowerApp].[ProjectBoard]',
ProjectName = TextInput3.Text
).Id
)
I don't understand the other method that you propose, of getting it directly from a ClearCollect
Maybe you have more formula examples?
Thanks

Was this reply helpful? Yes No