Unable to lookup GUID value Patched to SharePoint

(0) Share

Report

Posted on by Data_Enthusiast

383

Hi Power Apps Community,

Issue: I am trying to Lookup a GUID value in SharePoint - which is generated in Power Apps and then Patched to SharePoint using the following:

Set(varGUID, Text(GUID()));

If the value matches, then the Checked.Icon with appear. The following is on the Icon property:

If(IsBlank(LookUp(SP List, GUID in varGUID)), "", Icon.Check)

Unfortunately, no result is returned when performing the required action.

Will appreciate any help.

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (2)

Verified answer

mdevaney 29,989 Moderator on at

Like (0)

Report
@Data_Enthusiast

LOOKUP only returns a single result so you do not want to use the IN operator which can return multiple results.

If(IsBlank(LookUp(SP List, GUID = varGUID)), "", Icon.Check)

Also, when using a variable in a LOOKUP the function becomes non-delegable. If your GUID is beyond the delegation limit of 500 rows (or 2,000 rows if you increased the settings) the record will not be found.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Data_Enthusiast 383 on at

Like (0)

Report

Hi @mdevaney
Thank you for the response and clarity.
I changed the script as suggested by your post, but unfortunately no icon value is returned - when there is a GUID value.
I can confirm that the SP List which is referenced for the Lookup does have the associated GUID value.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Data_Enthusiast
How many rows in your SharePoint list?

Was this reply helpful? Yes No
Data_Enthusiast 383 on at

Like (0)

Report

@mdevaney
I had the delegation warning pop-up. As a result, I referenced my SharePoint Lists in a Collection to avoid the warning.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Data_Enthusiast
Can you confirm the record you are targeting appears in your collection? The collection will only store as many records as the delegation limit setting allows.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Data_Enthusiast 383 on at

Like (0)

Report

@mdevaney
Yes, I can confirm that the value being targeted appears in the Collection.
However, I noticed now that the value is between "<div></div>" property. I'm guessing this could be the issue...

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Data_Enthusiast

Agreed. I do not know why there would be HTML code beside your GUID. Any ideas?

Was this reply helpful? Yes No
Data_Enthusiast 383 on at

Like (0)

Report

@mdevaney
The column which holds the GUID value in SP is a Multi-line text field. I'm assuming that this may be the reason....
But will investigate more to see why it returns the value in this format.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Data_Enthusiast
Maybe it has to do with how you are writing the value to the datasource.

Was this reply helpful? Yes No
Data_Enthusiast 383 on at

Like (0)

Report
@mdevaney
I am Patching the variable:
Patch('SP List', {GUID: varGUID})
The value displayed from SharePoint shows accordingly.

Was this reply helpful? Yes No