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
Solved! Go to Solution.
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)
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)
User | Count |
---|---|
184 | |
123 | |
90 | |
45 | |
42 |
User | Count |
---|---|
267 | |
160 | |
129 | |
81 | |
76 |