Hi all. I have an PowerApp where the user can upload photos from their phone, and send them into SharePoint, with some metadata. The strange thing is, taht the collection always shows an empty row, and I don´t know what is wrong.
Step 1. the user sets some metadata taht should be attached to the photo
.Set metadata
Step 2. The user collects the photos that should have the same metadata
If you notice there is a blank field in the top (don´t know where it comes from).
Step 3. If I switch to the collection I can see that the empty row is part of the collection
Has anyone tried that before? I have absolutely no idea how to fix this, and I cannot understand how i have gotten to create this extra row in the collection. Hop that someone can help me with this.
Greetings from Denmark
Frank Nielsen
Solved! Go to Solution.
Hi timl. This is the code I have added to the button that collects photo and metadata.
Collect(Photos; { Photo:UploadedImage2.Image; Filename: Concatenate("File"; Text(Now()); "-"; Text(CountRows(Photos)+1); ".jpg"); BIO: TextInput3.Text; Track: TextInput6.Text; Activ: TextInput4.Text; Loc: TextInput7.Text; Aar: TextInput1.Text})
The fun thing is, taht the problem seems to be a bit temporary. Sometoimes when I test, all pictures get the metadata, and I´m a happy guy. But sometimes the metadata is not attached to the picture. It is deliberately, that the TextInput fileds is not renamed, just in case if you're wondering.
/Frank
Hi Frank,
I don't quite have an answer for you but I'm tagging @ericonline who I think has a similar issue with blank rows.
Eric - I thought this might be interesting. The thing it has in common is that it's a phone app, and it uses a collection and SharePoint.
@venseben - are you using the Patch function to save the record? If so, would you be able to share the code?
My app appears to be writing empty rows to Sharepoint list only when "coming back online" via the mobile app and writing Saved records using the Collect() function. Hope that makes sense.
Symptoms:
Code:
Hi @timl and @ericonline. THX for quick replys, awesome service form you.
I ended up deleting the collection, and building up a new collection from scratch. Now i works like a charm (almost), because i managed to remove the empty row.
But when i take a look at the gallery, the first row is still missing all the lovely metadata, I have attached to the photo. Could it be because the first photo is number "0"? the filename is a concatenate between the now function and count of rows, and if the row number is "0", then maybe the metadata is uanable to be stored?
/Frank
Hi Frank,
I'm glad that you're making a bit of progress on this. Could you show us the code that you're using? This might help us to better understand what the cause of the problem is. Are you simply Patching your new colleciton to SharePoint?
@ericonline - thanks for clarifying your issue. I still hope you find an answer soon.
Hi timl. This is the code I have added to the button that collects photo and metadata.
Collect(Photos; { Photo:UploadedImage2.Image; Filename: Concatenate("File"; Text(Now()); "-"; Text(CountRows(Photos)+1); ".jpg"); BIO: TextInput3.Text; Track: TextInput6.Text; Activ: TextInput4.Text; Loc: TextInput7.Text; Aar: TextInput1.Text})
The fun thing is, taht the problem seems to be a bit temporary. Sometoimes when I test, all pictures get the metadata, and I´m a happy guy. But sometimes the metadata is not attached to the picture. It is deliberately, that the TextInput fileds is not renamed, just in case if you're wondering.
/Frank
Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Did you miss the call?? Check out the Power Apps Community Call here!
User | Count |
---|---|
259 | |
206 | |
76 | |
38 | |
32 |
User | Count |
---|---|
344 | |
218 | |
117 | |
71 | |
54 |