Error Message: SharePoint calculated column as unique ID for PowerApps Form

[Titiwai]

Background: running a downdown in EditForm and want to have the field lookuped based on calculated unique ID in Sharepoint List.. But received a warning messange and does not work.

Wonder if there is anything to do with execution or I'd chosen a wrong approach? Less then 500 records.

sessionId:1d172307-83ad-4515-a269-5dad80ab1113

[sopatte]

What's your formula?

[Titiwai]

Dropdown>Default>LookUp(Timesheet,Identifier=ThisItem.Identifier,Title)

&

Sharepoint Calculated Column For Unique ID>=[Title]&DAY([Date])&MONTH([Date])&YEAR([Date])