Collect( COLLECTION Lookup columns in sharepoint

[Anonymous]

Hi,

In have several apps that i have made, origionally they were pretty straight out of the box sharepoint create app, the only continous issue we had was our users were continiously out of mobile reception as such, I have recently made them all offline and use the collections functions,

Each app has four screens, **SEE IMAGES

1.BrowseScreen BrowseGallery

2.DetailScreen DetailForm

3.Canvas screen (With custom text inputs and dropdowns) **NO form all on the canvas

4 EditScreen EditForm

My users are presented with the browse screen (1) upon which they select to add a new entry ( + Red Arrow) or edit an old entry. ( > Orange Arrow) 

The add arrow takes them to the canvas screen (3), where they are able to fill out the details and submit using the 

If(Connection.Connected
,Patch('SHAREPOINTLIST',
Defaults('SHAREPOINTLIST'),
{
CHOICE COLUMN: DROPDOWNCHOICECOLUMN.Selected,
NUMBER COLUMN: Value(NUMBERCOLUMN.Text),
TEXT COLUMN: TEXTCOLUMN.TEXT
}
)
,Collect(RANDOMCOLLECTION,
{
CHOICE COLUMN: DROPDOWNCHOICECOLUMN.Selected,
NUMBER COLUMN: Value(NUMBERCOLUMN.Text),
TEXT COLUMN: TEXTCOLUMN.TEXT
}
)
);
UpdateContext({ResetVar: true});
UpdateContext({ResetVar:false});
Navigate(DetailScreen1, ScreenTransition.None)

(The app has hidden timers and labels to send the data to the database upon connection, all works great) the detail screen (2) is then shown for 15 seconds and are taken back to the (3) to reenter another entry, (Stops double entries and makes them think)

And if they edit they are shown the detail screen (2) then they select the edit option to be taken to be taken to the Editform screen (4) **only if they have internet connection of course

My issue is some of my apps need to use Lookup columns to enter the data for powerbi and flow reasons

I need the syntax (or know how) for collect( 

for Lookup Columns of a choice field in another database (Current workaround is to have a choice column in that data base)

for image columns (images taken from a camera on the app)

for person columns (users they need to assaign tasks or reference too, then i have flows setup)

for date columns (users to select a date to be added to sharepoint so flow sends that date to someone)

Google has been completly useless in finding this information, i cannot find it in the microsoft powerapps guides or on this forum itself and these questions are not answered in youtube tutorials etc

Id really appreciate some help.

Thankyou

[Anonymous]

Date column issue has been resolved, i just ask my users to put the date in as DD/MM/YYYY 

Date_x0020_Completed : DateValue(Text(Can_Datecompleted.Text,"[$-en-US]yyyy-mm-dd"))

Anyone know how i fix my other problems?

[Anonymous]

Person column i just created a choice column with all relevent people in there and a dropdown with same people will send the flows from there.

[v-xida-msft]

Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you want to collect the related column data into your collection using Collect() function?

Based on the needs that you mentioned, I have made a test on my side, please take a try with the following formula:

Collect(
            LocalCollection, 
            {
             LookUpColumn: {
                                 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"           
                                  Id: LookUp(ReferencedSPList, ReferencedColumn = LookUpColumnDropdown.Selected.Value, ID),
                                  Value: LookUpColumnDropdown.Selected.Value 
                           },
             ImageColumn: Camera1.Photo,
             PersonColumn: PersonDropdown.Selected.Value,
             Date_x0020_Completed : DateValue(Text(Can_Datecompleted.Text,"[$-en-US]yyyy-mm-dd"))
            }
)

Note: The ReferencedSPList represents the SP list your LookUp column references values from. The ReferencedColumn represents the column (your LookUp column references values from) in your ReferencedSPList.

Note: When you save the picture file captured via your Camera control into your SP list, the picture file would not be displayed as a picture in your SP list. The output of Camera control is a Image Blob URL Data rather than a image file.

Best regards,