Answered

Dropdown doesn't list up data form sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello there,

I am currently building my first "bigger" powerapp. But I have some problems with receiving the data in my dropdown box from SP.

I am using the following command: Choices(Reservationslist . 'TimeRes')

I am sure, that it must be a small mistake, which I am not able to recognize because I am new on powerapps

I attached some screenshots

Thanks for your help 😀

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
Remove the empty spaces like this

Choices(Reservationslist.'TimeRes')

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Use:
Reservationslist .TimeRes

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

Like
a
(0)

Report
Copy link

Link copied!

Hello,
Thanks for the quick response.
I already tried it by myself. It does not make a difference. The error still exists.

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

Like
a
(0)

Report
Copy link

Link copied!

Hello mdevaney,

Already tried it. Unfortunately it doesn't make a difference.
Error: Name is not valid; function choices has some invalid arguments.
Thank you anyway

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

You need to REFRESH your datasource after creating the new column in SharePoint. Go to the left-side menu, click the three dots beside the SharePoint datasource and then click "Refresh"

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

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

Like
a
(0)

Report
Copy link

Link copied!

I can't find this option "refresh datasource" on my sharepoint online list.
Can you be more specific?

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

The Refresh is done within PowerApps, not SharePoint. See image below.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

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

Like
a
(0)

Report
Copy link

Link copied!

Hello mdevaney,

Today when I started up my computer, powerapps automatically asked me for permission to access the sharepoint site. Even when the sp site and the powerapp was created with the same user which has the administratior role
It looks like it works since then.
Maybe your soulution would perform the same task.

Thanks for helping.

Was this reply helpful? Yes No