Trouble populating my powerapp gallery data to my Sharepoint List

(0) Share

Report

Posted on by SM17

Hi there

Hoping someone can assist me.

I'm VERY new to PowerApps and just teaching myself as I go.

My PowerApps data is not populating my SharePoint list at all. It is connected as I can see the 3 little marks suggesting a new row is loading and clicking on details shows the row number has increased but nothing is displayed.

What could be causing this?

Any assistance would be so greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (41)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

did you refresh the list/source ? How are you saving - patch or form submit?

Was this reply helpful? Yes No
SM17 72 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks so much for replying. I really appreciate it.
It's hard to explain but basically the app flow is:
Screen 1 is a gallery where customer selects location
This info along with time & date is automatically populated on screen 2 with 2 editable fields (issue type drop down & issue detail).
On the bottom of the same screen, customer can scan their profile QR barcode. Then press review.
This takes customer to last screen where they can review all provided data (in gallery2).
The profile QR barcode contains 3 pieces of data relating to their id, name, phone. The barcode reader is meant to be scanning this and saving to a ScannedData collection. This info is also meant to be displayed in gallery2 but this isn't displaying in the gallery. The rest is.
Hence I believe the 3x customer fields below are incorrect too.

Patch(
APCOApp_CustomerFeedback,
Defaults(APCOApp_CustomerFeedback)
);
{
SiteName: Site.Text,
siteId: 'Site No'.Text,
date: Date.Text,
time: 'Issue Time'.Text,
customerId: customerid,
customerName: customername,
customerPhone: customerphone,
IssueType: 'Issue Type'.Text,
IssueDescription: Issuedescription.Text
};
Navigate(BrowseGallery1, ScreenTransition.None)

Was this reply helpful? Yes No
SM17 72 on at

Like
a
(0)

Report
Copy link

Link copied!

The onscan barcode reader formula is:

Set(
BarcodeReader1_Value,
true
);
Set(
parsed,
Substitute(
Substitute(
BarcodeReader1_Value,
"\n",
""
),
"\",
""
)
);
Set(
fields,
ForAll(
Split(
parsed,
":"
),
{Result: ThisRecord.Value}
)
);
Set(
id_value,
Substitute(
Index(
fields,
2
).Result,
"""",
""
)
);
Set(
name_value,
Substitute(
Index(
fields,
3
).Result,
"""",
""
)
);
Set(
phone_value,
Substitute(
Substitute(
Index(
fields,
4
).Result,
"}",
""
),
"""",
""
)
);
Set(
customerId,
Index(
ForAll(
Split(
id_value,
","
),
{Result: ThisRecord.Value}
),
1
).Result
);
Set(
customerName,
Index(
ForAll(
Split(
name_value,
","
),
{Result: ThisRecord.Value}
),
1
).Result
);
Set(
customerPhone,
phone_value
);

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I think your patch may not be supplying the correctly formatted values. There are a few videos online that provide what's needed for each column type. I can't find it right now but google powerapps patch and you should be able to find it.

Was this reply helpful? Yes No
SM17 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much. I will give it a go 😊

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

this might be the one.. https://www.youtube.com/watch?v=g9ChYuTdNd4 he has others too...very helpful videos

Was this reply helpful? Yes No
SM17 72 on at

Like
a
(0)

Report
Copy link

Link copied!

You're a legend. Thanks so much. Really appreciate it 🙏

Was this reply helpful? Yes No
SM17 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Another issue I'm having is that my QR barcode data which is meant to be saved in a collection called ScannedData, is not populating in my gallery2.

See below.
I'm getting this delegation limit error msg as well but it wasn't working before getting that msg either.

I don't seem to be getting any error messages related to my barcodereader1 onscan property so really stumped!

Any suggestions?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I haven't used a bar code reader, so may not be much help. Do you know if the data is coming back? can you collect it in a collection and then view it? (not in gallery but within the tools part)

Was this reply helpful? Yes No
SM17 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for replying to my post @Anonymous. Really appreciate it.
I'm that new to PowerApps that I didn't even know that tool section existed!
hmmm, not much happened at all I'm afraid.
Problem is, I keep searching the internet for help and then change my code and then go backwards or around in circles!
I really wanted to achieve this and have a tight deadline by Monday but don't think it's going to happen.

I was told that the barcode reader can only display data in a gallery/table and to use a collection to save and use it throughout the app. However, it doesn't display.
My barcode is a QR code with 3 bits of info that I need to extract and save in separate columns of a SharePoint list. However, nothing is making its way to my sharepoint list. It seems to add a new row but with no data attached but my recent attempts have resulted in the following...

Would love to know your thoughts.

Was this reply helpful? Yes No