Unanswered

Problems getting IDs of a SharePoint list from PowerApps

(0) Share

Report

Posted on by maxiq_2k

Good evening community, I am having problems obtaining a SharePoint ID from PowerApps, I am using the LookUp formula, I am using this formula within a flow that requires an ID to update a SharePoint element, when I go to see the result of the Flow , the "ID = 0", what could be the problem? Value(LookUp(VencLocal;EanSH=confean.Text && sucursal12=SucursalSH && FechaSH=Text(DatePicker2;"[$-es-ES]dd/mm/yyyy";"es-ES");ID))

Categories:

AI Builder

I have the same question (0)

All responses (2)

Answers (1)

v-albai-msft on at

Like (0)

Report
Hi @maxiq_2k ,
Please pay attention and check below things:
1. Is SucursalSH the name of your TextInput control? If yes, you should use sucursal12=SucursalSH.Text in your formula.
2. What’s the column type of FechaSH in your SP ? If this is a Date column, you should use this as the condition(remember to add SelectedDate for the Date Picker control):
Text(FechaSH;"[$-es-ES]dd/mm/yyyy";"es-ES")=Text(DatePicker2.SelectedDate;"[$-es-ES]dd/mm/yyyy";"es-ES");
You can add some labels and set them to First(VencLocal).FechaSH and Text(DatePicker2.SelectedDate;"[$-es-ES]dd/mm/yyyy";"es-ES") to compare their date format.
For example, my SharePoint has a Date column called "date1", this is its default result format(with time):
This is the result of my date picker control:

After change(this time you can lookup a record and get its ID):

So on your side, you can try this:
LookUp(VencLocal; EanSH=confean.Text && sucursal12=SucursalSH.Text && Text(FechaSH;"[$-es-ES]dd/mm/yyyy";"es-ES")=Text(DatePicker2.SelectedDate;"[$-es-ES]dd/mm/yyyy";"es-ES"); ID)
Best regards,
Allen

Was this reply helpful? Yes No
Verified answer

v-albai-msft on at

Like (0)

Report

Hi @maxiq_2k ,
Sorry for delay. I don't know why your reply disappear.
First let me explain why you receive this message:
"Advertencia de delegación" is just a Delegation warning message, not an error. This is because DateTime and Date values in SharePoint are still not yet delegable when using Lookup(). So you will get that warning and the query will only work on the first number of records in your Advanced settings (500-2000).

If the number of list items in your list is more than 2000, you can get workarounds from this article.
Power Apps Delegation – SharePoint – Practical Power Apps

Besides, from your screenshot, I think you should use "DatePicker2.SelectedDate" instead of "DatePicker2" inside your formula:
Text(FechaSH;"[$-es-ES]dd/mm/yyyy";"es-ES")=Text(DatePicker2.SelectedDate;"[$-es-ES]dd/mm/yyyy";"es-ES");
Best regards,
Allen

Was this reply helpful? Yes No