cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

need a unique ID in my formula

I am trying to use the following formula which send data to sharepoint using a flow;

LostProperty.Run("EditForm1_1.LastSubmit.ID.jpg",First(ColPhoto).Url,DCVItem2,(DCVDate2.SelectedDate),DCVStation2.DisplayMode,DCVDescription2)

The issue is everytime i submit the name part of the formula is the same so just overrides the existing record. I tried to include a formula to make it unique but it just takes the exact text i have added. I have hightlighted the name part of the formula tha needs to be unique.

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps
Power Apps

If you want to use the unique ID from the form, you can use it outside double quotes, and use the & operator to concatenate it with a prefix and the .jpg suffix, like in the example below:

LostProperty.Run(
    "Image" & EditForm1_1.LastSubmit.ID & ".jpg",
    First(ColPhoto).Url,
    DCVItem2,
    (DCVDate2.SelectedDate),
    DCVStation2.DisplayMode,
    DCVDescription2)

View solution in original post

1 REPLY 1
Power Apps
Power Apps

If you want to use the unique ID from the form, you can use it outside double quotes, and use the & operator to concatenate it with a prefix and the .jpg suffix, like in the example below:

LostProperty.Run(
    "Image" & EditForm1_1.LastSubmit.ID & ".jpg",
    First(ColPhoto).Url,
    DCVItem2,
    (DCVDate2.SelectedDate),
    DCVStation2.DisplayMode,
    DCVDescription2)

View solution in original post

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (74,850)